Is VBA code a Mac different than VBA on a PC?

[Hulton]

I am going to start learning VBA and how to write macros, but I have a Mac (2010 model, I believe). I also have MS Office 2011 on the Mac. I was wondering if the syntax/code that you write on a Mac is different than it written on a PC? Ultimately, I need to be able to write VBA on a PC, but if its the same on both then its no problem. Also, I am new to programming. I know a little bit of HTML and the basics of SQL, if that helps.

 

[Misca]

Microsoft has replaced VBA with AppleScript (for Macs, that is):

http://support.microsoft.com/kb/113891

 

[Jon Peltier]

AppleScript is old news, what you had to use in Excel 2008 from which Microsoft had removed VBA.

In Excel 2011 for Mac, Microsoft has re-introduced VBA, and it's even finally the same version of VBA that Excel for Windows has been using all along. However, there are a substantial number of differences in how Excel itself behaves between the two platforms, and in how VBA interacts with these platforms. I've only done enough testing to know it's going to be a lot of work to make my stuff compatible.

Ron de Bruin has started documenting the differences between Mac and Windows Excel VBA in VBA code in Mac Excel 2011 and Windows Excel.