Running Excel VBA Macro from A.S.

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:

  1. ‘test.xls’ cannot be accessed. The file may be read-only or you may be trying to access a read-only location."
  2. “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!!??