Posted: Mon Sep 14, 2009 4:04 am Post subject: Visual Basic macro conversion
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
Joined: Jul 05, 2005 Posts: 685 Location: North West England
Posted: Mon Sep 14, 2009 8:59 am Post subject:
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. _________________ MacBook Pro
13-inch, Mid 2012
Processor 2.5 GHz Intel Core i5
Memory 4 GB 1600 MHz DDR3
Graphics Intel HD Graphics 4000 512 MB
OS X 10.9.3 (13D65)
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You cannot download files in this forum