MacTech has a 150 page manual describing how to convert from VBA macros to Applescript.