Excel on the Mac

[mortgageman]

I was recently in an Apple store and was checking out the Mac. I went into Excel and aside from the fact that it looked nothing like Excel on the pc, I couldn't find a way to get into the VBA environment.

Basic question is this - Can I take a excel 2003 sheet - that has VBA macros - and run it on a Mac? (I'd rather know before I buy )

Thanks

 

[RoryA]

It depends on the version of Excel. If it's Excel 2008 on the Mac, then no - it does not support VBA at all. If it's Excel 2004 or earlier then yes, but some code is different on the Mac.

 

[mortgageman]

It depends on the version of Excel. If it's Excel 2008 on the Mac, then no - it does not support VBA at all. If it's Excel 2004 or earlier then yes, but some code is different on the Mac.

well, it sounds like portablity is out the window then. OMT (Off My Topic), Does 2008 have some other programming environment?

 

[Domski]

HALH (Have a look here)

http://www.macworld.com/article/131558/2008/01/excel2008.html

Dom

 

[mortgageman]

HALH (Have a look here)

http://www.macworld.com/article/131558/2008/01/excel2008.html

Dom

Yeah - this seems to confirm that if you have macros as part of your pc
excel application, you really can't port unless you get that "boot camp" running on your apple. I called my local apple store and asked how much it would be for them to install windows on an mac that I wanted to buy, and they said "by law" they could not install windows. I guess I missed that act of congress.

 

[sailepaty]

You might want to check this.

http://theappleblog.com/2008/05/13/microsoft-patches-office-commits-to-vba-support/

Early on May 2008 I sent a file to Mac user with macros included and it’s working since then.

 

[RoryA]

They must not be using 2008 if the macros work.

 

[sailepaty]

Have you tried macros in Excel 2008 with SP1?

Regards

 

[RoryA]

Yes. My Excel 2008 is patched up to 12.1.1 and if you open a workbook with vba macros you still get the warning about them not working (and the option to remove them). Note that I am talking about VBA macros, not XLM macros, in case that's what you are referring to. Additionally, there is nothing in that article I can see that mentions adding VBA functionality to 2008 and I'm pretty sure that if they had it would be headline news!

 

[sailepaty]

Thanks for the clarification.

Regards