Office Excel 2003 file runtime error when run in excel for mac 2004

[Long]

Hi,

I am trying to run an excel file that includes VB modules which was
created in a PC with Office Excel 2003 SP2 and VB editor 6.3 in a mac
with excel for mac 2004 and I get runtime errors.

Any ideas?

Any help would be very much appreciated!

P.S The file opens fine when I delete the modules.

 

[JE McGimpsey]

Hi,

I am trying to run an excel file that includes VB modules which was
created in a PC with Office Excel 2003 SP2 and VB editor 6.3 in a mac
with excel for mac 2004 and I get runtime errors.

Any ideas?

Any help would be very much appreciated!

P.S The file opens fine when I delete the modules.

You may be getting runtime errors because (a) MacXL includes only VBA
version 5, and (b) if your workbook contains ActiveX controls, those are
only supported in on the Windows platform.

To run in MacXL, ensure no VBA6 commands/features are used, and replace
any Control Toolbox (ActiveX) controls with controls from the Forms
toolbar.