http://blogs.msdn.com/nadyne/archive/2010/03/02/q-a-is-visual-basic-returning-to-office-mac.aspx
go ahead, mac my day
a Macintosh girl in a Microsoft world
Word team blog
Q&A: is Visual Basic returning to Office:Mac?
My post about questions we got at Macworld 2010 raised some questions, one of which was this one:
The biggest question in my mind is: will Office 2011 support visual basic for excel?
Yes. We announced in 2008 that Visual Basic for Applications will return to the next version of Office (you can read the blog post about it here: saying hello (again) to Visual Basic). And it's still true: Office:Mac 2011 will support VBA.
We're bringing the latest and greatest version of VBA to the Mac, which is 6.5. We'll still continue to support AppleScript and Automator for your Mac-only scripting needs, and we'll also support VBA for your cross-platform scripting needs.
For those of you who are interested in getting started with writing Office scripts with AppleScript, I have to recommend Mactech magazine's VBA to AppleScript transition guide. It's 150+ pages of AppleScript goodness, and I've only heard awesome things about it.
Published Tuesday, March 02, 2010 7:36 AM by nadyne
Filed under: Office 2011
-
-
that is awesome
-
ltcommander_data Notebook Deity
As the blog post itself mentioned, this has been announced and known since 2008. It is interesting that they say VBA 6.5 is the latest version when VBA 7 is coming with Office 2010. I'm not a heavy VBA user myself, but I believe a common complaint with VBA support in previous versions of Mac Office is that it isn't as complete as VBA on Windows which can lead to problems, although I suppose that can be said for comparisons between Mac Office and Windows Office in general. Hopefully, VBA in Office 2011 will improve things.
Visual Basic returning to the Mac!
Discussion in 'Apple and Mac OS X' started by Khris, Mar 2, 2010.