After my posts this past August about the removal of VB from Mac Office 2008, lots of people asked about how to convert VB code into AppleScript. I had always intended to write up a post with some simple examples but never actually found the spare time to do so. However, Paul Berkowitz, along with the help of some other stellar Microsoft MacBU MVPs has written an excellent tutorial with some concrete and very relevent examples of VB macros and their AppleScript equivalents.
MacTech Magazine announced on Wednesday that their upcoming April 2007 issue will contain the entire 150-page book! I saw a slightly-pre-release copy of the book at MacWorld and I think it will be an excellent reference/HowTo for anyone who has created custom solutions in VB for the Mac.
I know this doesn’t address the cross-platform issues surrounding VB but it should give you some ideas of the richness of AppleScript and our support for it in Mac Office 2008.