I just upgraded to Office 2004 to be able to get an AppleScript in Entourage to kick off a VBA macro in Excel. But no luck.
To test things, I created an Excel file (“test.xls”) with a one-line VBA macro named “test.” It just puts up a dialog box with the message “success.” I’m calling it from A.S as follows:
tell application “Microsoft Excel”
run VB macro “hard disk:users:xxx:desktop:test.xls!test”
end tell
I get two successive error messages:
- ‘test.xls’ cannot be accessed. The file may be read-only or you may be trying to access a read-only location."
- “Microsoft Excel got an error: “hard disk:users:xxx:desktop:test.xls!test” doesn’t understand the run VB macro message.”
“test” file permissions are -rw-r–r–.
FWIW, I did not remove the old Office vX yet. I read on some other site that this may cause problems.
This has been endlessly frustrating. HELP!!??
Steve