Excel VBA MAC and PC compatibility

[sitterlin.michel]

Hello,

I developed Excel VBA programs on PC and ... usually they don't work on
MAC!! (Last example, I had an "Error 3209 - error defined by the Application
or the Object").

I would appreciate if somebody could give me the address of a site giving
all the differences between MAC Excel VBA and PC Excel VBA.



Thanks for your help,



Michel S.

 

[JE McGimpsey]

I developed Excel VBA programs on PC and ... usually they don't work on
MAC!! (Last example, I had an "Error 3209 - error defined by the Application
or the Object").

I would appreciate if somebody could give me the address of a site giving
all the differences between MAC Excel VBA and PC Excel VBA.

I don't know of any...

The first place to look is MacXL VBA Help ("Differences between Excel
VBA for Windows and Excel VBA for the Macintosh").

Next, MacVBA is version 5.0, the same as WinXL97. VBA6 functions (e.g.,
Join, Split, Rand, Replace, etc.) will not work. I use VBA5 functions
and conditionally compile them.

ActiveX doesn't work on Macs. Use controls from the Forms toolbar
instead.

There are a (very) few syntax differences. For instance, the
GetOpenFileName function argument FileFIlter has incompatible syntax.\

Finally, Windows-specific API calls will not, of course, work on Macs.