How do I launch VBA macros in Excel from AppleScript? (Excel X for Mac)
The AS dictionary for Excel says this can be done, but apparently it was buggy (see http://groups.google.com/group/alt.comp.lang.applescript/browse_thread/thread/f82f1382ff150127/89c8328b7068bdca%2389c8328b7068bdca?sa=X&oi=groupsr&start=1&num=3). A service pack was supposed to address the problem.
Evaluate “DNSBLs to test 4.xls!Test()” launches Excel, opens the correct file, but doesn’t launch the macro.
The alt.comp.lang.applescript thread cited above said to use this work-around:
OnTime EarliestTime (time string of (current date)) RunMacro “DNSBLs to test 4.xls!Import_Spam_IP_Addr()” LatestTime (time string of (current date))
It also launches Excel and opens the right workbook, but doesn’t launch the macro.
HELP!!??
TIA, Steve