PC-based Excel File opening on a Mac

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Darren - 13 Sep 2007 05:39 GMT

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?

Reply to this Message

Michael Vilain - 13 Sep 2007 06:58 GMT

> 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
[quoted text clipped - 6 lines]
>
> Just wondering whether anyone has some thoughts on this?

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

Signature

DeeDee, don't press that button! DeeDee! NO! Dee...

Reply to this Message

Bob Greenblatt - 13 Sep 2007 13:05 GMT

On 9/13/07 1:58 AM, in article
vilain-8DEEC6.22581812092007@comcast.dca.giganews.com, "Michael Vilain"
<vilain@spamcop.net> wrote:

>> 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
[quoted text clipped - 8 lines]
>
> 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.

Signature

Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom

Reply to this Message

Mac Forum / Applications / Excel / September 2007

PC-based Excel File opening on a Mac