MAC Compatibility for VBA!

[xonio]

Hi folks,

Any Windows/Mac experts to advise me if an Excel worksheet with VB
programming built into it is compatible at all with Excel for MA
computers? Mac computers seem to open the worksheet but not be able t
read the VBA coding. Is there a way to achieve this compatibility?

Thanks.

x

 

[JE McGimpsey]

MacXL uses VBA5, so if your code works in XL97, it will likely work in
MacXL, with a couple of exceptions:

- MacXL does not support ActiveX, including ActiveX controls from the
Controls Toolbox - use Forms controls instead

- There are a (very) few syntax differences between Mac and WinXL VBA,
primarily to do with File I/O. In most cases, the differences are
ignored if possible, but some can cause run-time errors (e.g., the
Filefilter property in the GetOpenFileName method).

- SendKeys does not work in MacXL. SendMail doesn't either, though you
can find a simple workaround at

http://www.mcgimpsey.com/macoffice/excel/macexcelsendmail.html

And of course, if your VBA uses Windows API calls, they won't work on
the Mac.