This is a basic applescript for excel but I keep getting an error in 10.10.1. This same code worked in all previous iteration of osx.
Has anything changed? Any help would be appreciated.
tell application "Microsoft Excel"
activate
activate object worksheet "Sheet2"
end tell
Syntax Error:
Expected end of line, etc. but found identifier.
StefanK
#2
Hi,
according to the dictionary the parameter types of activate object are pane, sheet, window and workbook. Try
tell application "Microsoft Excel"
activate
activate object sheet "Sheet2"
end tell
Maybe Yosemite is just less tolerant
actually that didn’t work but this did
tell application "Microsoft Excel"
tell active workbook
activate object worksheet "Sheet1"
end tell
end tell
There seems to be a great deal of things broken/changed in applescript for yosemite. A lot of my scripts are broken.
thats odd it works on one computer and doesn’t work on the other.
Ok even more stranger. I took that script to the other computer and it worked without any issues.