excel save as csv
excel save as csv
- Subject: excel save as csv
- From: Sam Rutherford <email@hidden>
- Date: Fri, 13 Nov 2015 17:32:19 -0600
| i have a script that saves an excel file as a cvs. it worked for years with excel 11.5.9, but i recently had to upgrade my os to 10.11.1. excel 11.5.9 no longer worked so i had to upgrade it to 15.15. here’s the script:
tell application "Microsoft Excel" open file "Macintosh HD:Users:sam:Desktop:newtargetinv.xls" tell workbook 1 tell sheet 1 save in "Macintosh HD:Users:sam:Desktop:newtargetinv.csv" as CSV file format end tell close without saving end tell end tell
like i said. it used to work flawlessly. now it results in this error:
error "Microsoft Excel got an error: Parameter error." number -50
does anyone know how to fix my script?
by the way. i am pretty much a noob. i dont write applescripts. i find them and tweet them.
thanks in advance.
sam
________________________________________________________________ Sam Rutherford Music City Metals 615/255-4481
|
_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden