VBA on MAC

[mart1n23]

Hi everyone,

I'm looking to purchase a copy of Microsoft Office for my MAC, mainly to use Excel with VBA, but i've read that VBA isn't included on 2008. Is that correct? Why not?

Is it included in the old 2004 release, and if so, is it fully functioning?

 

[Domski]

It was dropped in Office 2008 for the Mac. Something to do with the timescales for converting the code to work on the lastest Mac system architecture. I believe it will be making a return for the next version.

As for 2004 VBA I've never used a Mac so afraid I'm not sure what the differences are between VBA on the Mac and PC but I'm sure I've read that there are some.

Dom

 

[RoryA]

VBA in Excel 2004 is basically VBA 5, which is what you got with Windows versions of Excel through Excel 97.

 

[Macropod]

VBA in Excel 2004 is basically VBA 5, which is what you got with Windows versions of Excel through Excel 97.

Which means it doesn't support useful functions like Split and Replace.

 

[RoryA]

Or returning typed arrays from functions. And of course you can't use Windows API calls!

 

[SydneyGeek]

And pivot table code is much more convoluted in VB5 as well.
For 2008 you have to use AppleScript.

Denis

 

[mart1n23]

For 2008 you have to use AppleScript.

I'm still learning VBA at the moment, I don't want to have to learn AppleScript aswell. lol.

Ideally, I needed it to work cross-platform. I have a PC at work but a MAC at home. Despite the differences, was 2004 able to be used and edited on both platforms? Is the new version likely to be so?

 

[SydneyGeek]

For compatibility, you'd be best off creating the code in the Mac with version 2004. If you don't make any system calls (and if you're getting started you won't), it should run in Windows versions.
I don't know what the next Mac version holds; hopefully an update because Office 2010 is going through a VBA version change as well.

Denis

 

[RoryA]

Denis,
Love the tag line!

 

[SydneyGeek]

Thanks

Yours seems to change on a regular basis. Is the latest one beer-fuelled?

Denis