Here is one article about the VBA to AppleScript approach: VB to AppleScript.