Should an XLA for Windows Excel work on Mac Excel?

[Vik Rubenfeld]

Should an XLA written for Windows Excel work on Mac Excel? (If the XLA
is executed via an interpreter, it could be possible.) Thanks in advance
for any info.

-Vik

 

[JE McGimpsey]

XLA's are just workbook files saved in a different format, so in general
they will be compatible, subject to the same restrictions in any other
workbook:

1) MacXL does not support ActiveX
2) MacXL uses VBA5, equivalent to WinXL97. If you use VBA6 commands,
you'll need to conditionally compile or build in your own.
3) A few commands have platform specific arguments.
4) There are a very few commands (such as GetOpenFileName) that have
slightly different syntaxes.
5) Any Windows API calls will not work.
6) SendKeys, SendMail don't work in MacXL
7) Hardcoded paths (e.g., C:\, or using \ as a path separator) won't
translate.

 

[Vik Rubenfeld]

Excellent. Thanks for the info.

-Vik