Macro Errors - basic lang on data type 'range'

[freesoftwarewizard]

I am trying to use several dozen macros I had for excel.

They all use a dat type called "range" (for cell ranges).

When I run the macros, i get a 'basic" syntax error: "unknown data type range"

Any ideas?

if not, any idea of an easy way to remove rows that have back-to-back duplicate data in a specific column (such as all the 'extra" record that have the same date in column A for rows 4 thru 10) ??

thanks

joe c.

[FJCC]

I'm not familiar with programming Excel, so I can't certain about your 'range' variable. I do know that you cannot in general port Excel macros to Calc without significant changes. OOobasic is not identical to VB and the underlying API's are just different. For example, to create an object representing a cell range in Calc using OOoBasic, the code could look like

Code: Select all

Doc = ThisComponent  'assign the current document to the variable Doc
Sheet = Doc.Sheets.getByName("Sheet1")  'get the sheet named Sheet1
Cellrange = Sheet.getCellrangeBYName("A1:A10")

Your VB code is, I'm sure, different. I posted some links to resources helpful for learning to write OOo macros in this thread

[freesoftwarewizard]

the excel macros are actually just vbasic with a few 'extras' "range' is a dimension type.

I'm not really looking to spend a lot of time learning oobasic. just don't know where to find such a basic macro for scalc

but thanks for the reply!

joe c.

[Villeroy]

@ FJCC
Even in VBA you've got to program (somehow ). Particularly, you should know about data type "String" when calling anything by name.
getCellrangeByName("A1:A10")

[FJCC]

Doh! Well, that's embarrassing Thanks for the catch, Villeroy! I knew that if I just typed even the simplest code directly into a response without checking it, I would make a mistake.