MacTech has re-released Paul's 150-page guide for making the transition from VBA to AppleScript (originally printed in the April 2007 issue of the magazine, and also available in modified form on the Microsoft Mac BU site). It's highly detailed, with step-by-step instructions. It looks like I know what I'll be reading next week (and if I run into trouble I can always bug Cory for help).
You can download the guide as a PDF for $9.95US, or get the PDF plus a hardcover version for $19.95US. Both options include a free subscription to MacTech magazine, which is a great bonus for anyone who likes to dig into the underside of Mac OS X. If your wallet is a bit light, you can read the entire thing online for free.