I’m running 10.10.5 and ran the code below on mac1 and got the error below. But the mac 2 compiles and runs just fine. Trying to figure out needs to be corrected in mac 1 so that the code just works.
tell application "Microsoft Excel" activate activate object worksheet "Sheet1" end tell
Ok… the issue was parallels. Even having all the extensions open with microsoft excel for mac it some how still activated the parallels version.
so the fix
tell application "Microsoft Excel" activate end tell
RAN the above which lauched the parallels version. closed it and parallels ran the script again open the mac version.
Have a look at this:
http://stackoverflow.com/questions/4956445/virtual-machine-browser-is-considered-by-the-applescript-if-parallels-are-instal
-Chris