Will the "VBA Converter for Excel" convert VBA macros from Windows
spreadsheets so that they work in Excell 2004 plus if I create Macros
in Office 2004 will they work in Windows version of Excel?
The VBA Converter, as it says at the downloads page,
converts Visual Basic for Applications macros that are opened or
saved in Excel 5.0/95 Workbook format.
which only applies to older (pre-Office97/98) code.
For the most part, WinXL macros will work in MacXL if
a) No VBA6-only code is used (MacXL is VBA5)
b) No ActiveX controls are used.
There are a few minor exceptions (e.g., the GetOpenFileName method's
FileFilter argument has a different syntax between platforms).
And, again with a few exceptions, code written in MacXL98-04 will work
fine in WinXL.
In addition, there are workarounds you can use for the above. Using Form
Toolbar controls instead of ActiveX for example. Or writing the VBA6
command equivalents in VBA5, and using conditional compilation (see VBA
Help).
