Vba for mac vs applescript2/15/2023 ![]() Set MyRetCode to run VB macro "Macintosh HD:Users:xxx:Desktop:test.xls!test" Have you tried dealing with the return value from your macro? If you are invoking the MsgBox function in your test macro, you may need to allow the return value from MsgBox to pass thru back to AS. I read on some other site that this may cause problems. "test" file permissions are -rw-r-r- and it is sitting right on the desktop.įWIW, I did not remove the old Office vX yet, but renamed old Excel "Microsoft ExcelOld". "Microsoft Excel got an error: "hard disk:users:xxx:desktop:test.xls!test" doesn't understand the run VB macro message." The file may be read-only or you may be trying to access a read-only location."Ģ. Run VB macro "hard disk:users:xxx:desktop:test.xls!test"ġ. 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 (per the AppleScript Dictionary for Excel 2004): I want to use AppleScript in MS Entourage to kick off a VBA macro in Excel. Using MS Office 2004 and AppleScript 1.9.3. ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |