I am perplexed.somewhat experienced with applescript but trying more complex tasks.Here is the script:
tell application “Microsoft Excel”
activate
set myBook to active workbook
set mySheet to sheet 1 of myBook
set myrange to get range “A:A, C:C” of mySheet
delete range myrange
set destinationPath to (path to desktop as text) & "Newcase.csv"
save active workbook in destinationPath
end tell
The error message place shown is before end tell.it says Expected “” but found end of file
I have searched for an answer but to no avail.
Any ideas?
Thanks
Herb
Model: iMac
AppleScript: 2.4.3
Browser: Safari 537.78.2
Operating System: Mac OS X (10.7)