Should an XLA for Windows Excel work on Mac Excel?

V

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
 
J

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.
 
Top