PC-based Excel File opening on a Mac

[Darren]

I have a PC-based version of an Excel file which contains VBA.
Whenever I open it on a PC, I have to ensure the Macro security
settings are Medium or Low, so that the VBA works.

When a friend of mine goes to open the file on her Mac, she advises
that she doesn't have the option to down grade the macro security. It
takes a bit of time to load but she eventually gets into the file. She
gets a message "compile error: method or data member not found".

Just wondering whether anyone has some thoughts on this?

 

[Michael Vilain]

I have a PC-based version of an Excel file which contains VBA.
Whenever I open it on a PC, I have to ensure the Macro security
settings are Medium or Low, so that the VBA works.

When a friend of mine goes to open the file on her Mac, she advises
that she doesn't have the option to down grade the macro security. It
takes a bit of time to load but she eventually gets into the file. She
gets a message "compile error: method or data member not found".

Just wondering whether anyone has some thoughts on this?

I thought there wasn't a VBA in the Macintosh version of Excel.

 

[Bob Greenblatt]

I thought there wasn't a VBA in the Macintosh version of Excel.

There certainly is VBA in Mac Office 2004. VBA will be disappearing in Mac
Office 2008. The problem is that the PC file probably uses syntax or
functions from VB6 which are not supported in the Mac version of VBA. The PC
author probably had no intention (or idea about) making the VBA work cross
platform. We'd have to look at the code to determine the exact problem.