Excel to Open office macro error?

Question

I have this code to run a macro in Excel however i want to convert it to be used in Open Office.

Sub rowcntz()

Dim i As Integer

For i = 26 To 5000 Step 25

Range("A" & i).Select

ActiveCell.EntireRow.Insert

Next i

End Sub

When i try to run the macro in open office i get this error:

sub-procedure or function procedure not defined

Please help.

Answer 1

Hi,

Which version of OpenOffice? It wasn't until 2.4 that VBA got much support.

Use the latest build of OxygenOffice or NeoOffice then try again. OpenOffice from OpenOffice.org doesn't come with VBA support. You should use a complete build.

-Jim Gordon

http://360.yahoo.com/profile-i7JMeio7cqv...