Visual Basic macro conversion

[yoelf22]

Dear all;

I am trying to use a VB macro, that works well on excel / Windows, but won't run on my NeoOffice/mac 3.0 OS 10.5:

Macro text is as follows:

'Prints out formula as text
Function GetFormula(Rng As Range) As String
Application.Volatile True
GetFormula = "<-- " & Application.Text(Rng.FormulaLocal, "")
End Function


Thanks,

[James3359]

Unfortunately, NeoOffice cannot import or convert any Microsoft Word or Excel VBA Personal Macro Workbook or .xla library files. Macros in VB essentially have to be rewritten to run in NeoOffice/OpenOffice.org

It may be useful for you to look at this thread.