Submission + - MacTech's VBA to AppleScript Transition Guide
John C. Welch writes: "As pretty much everyone in the Mac Universe knows, (or should know), the next version of Office for Mac OS X, Microsoft Office 2008, will not support VBA. However, that doesn't mean Office Automation is dead on the Mac. It just means you can't use VBA. However, AppleScript will automate the holy beejeezus out of Office 2008, the trick is dealing with the conversion. To help with this, MacTech Magazine, along with Paul Berkowitz, AppleScript AND VBA maven have been working on a fairly massive transition guide. Details are at: http://www.mactech.com/news/?p=1009354 and in conjunction, the Microsoft Mac BU is offering discounts on MacTech subscriptions at http://www.mactech.com/vba/.
It's not a perfect answer to the VBA issue in Office 2008, and there may end up being better answers from folks like RealBASIC, but it's not a bad way to at least see what one of the more constructive options is going to be like."
It's not a perfect answer to the VBA issue in Office 2008, and there may end up being better answers from folks like RealBASIC, but it's not a bad way to at least see what one of the more constructive options is going to be like."