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.