When this news first came out several weeks ago I think I remember the macBU team listing AppleScript as the new preferred method of scripting rather than VB. The current Applescript reference guide for Excel alone runs 462 pages, and contains hundreds of classes and methods. I've Applescripted Excel on occasion with great success, and converting the actions to Automator actions is fairly easy.
I think that other than the obvious, potentially huge, burden of converting VBA to Applescript, I think that in the long run the move could end up strengthening the interoperability between MacOS and the Office suite.
Slashdot Mirror
When this news first came out several weeks ago I think I remember the macBU team listing AppleScript as the new preferred method of scripting rather than VB. The current Applescript reference guide for Excel alone runs 462 pages, and contains hundreds of classes and methods. I've Applescripted Excel on occasion with great success, and converting the actions to Automator actions is fairly easy. I think that other than the obvious, potentially huge, burden of converting VBA to Applescript, I think that in the long run the move could end up strengthening the interoperability between MacOS and the Office suite.