Posted: Mon Aug 06, 2007 6:22 pm Post subject: Macros in xls files
Is there much support for visual basic macros in xls files? I have a lot of xls docs from my MS Excell days and i'm making the effort to free myself from those days; nevertheless I don't want to reprogram all the macros I've written so have been using MS Office in a virtual Windows machine in the meantime.
The syntax error I'm getting is in a function parameter list:
Public Sub setBorder(myRange As Range, whichBorders As Variant, _
Optional lineStyles As Variant = xlContinuous, _
Optional weights As Variant = xlThin, _
Optional colors As Variant = xlAutomatic)
the toekn "xlContinuous" is not recognized. The macro works fine in MS Office 2003. Is there a library of MS-defined constants or whatnot that needs to be referenced? How might I add said library?
Joined: Apr 25, 2006 Posts: 2315 Location: Montpellier, France
Posted: Tue Aug 07, 2007 7:14 am Post subject:
NeoOffice gets its VBA support in Excel documents from the ooo-build project. If a VBA macro isn't working, the (most) likely cause is that it still hasn't been implemented by the ooo-build developers in charge of VBA.
Unfortunately, there is nothing we can do about it (other than report to ooo-build); you will have to find another way to perform the same action until that particular token gets implemented (in a future version, which doesn't always mean the next version).
If you really need to use this macro "as is", then you will have to use Microsoft Office 2004 for Mac (note that the upcoming Office 2008 for Mac will not support VBA macros at all).
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
