Re: excel save as csv
Re: excel save as csv
- Subject: Re: excel save as csv
- From: "Stockly, Ed" <email@hidden>
- Date: Fri, 13 Nov 2015 23:52:44 +0000
- Thread-topic: excel save as csv
Even better:
save as
filename "Macintosh HD:Users:sam:Desktop:newtargetinv.csv" file format
CSV file format
From: Los Angeles Times Los Angeles Times < email@hidden>
Date: Friday, November 13, 2015 at 3:54 PM
To: Sam Rutherford < email@hidden>, AppleScript Digest < email@hidden>
Subject: Re: excel save as csv
How about:
save as "Macintosh
HD:Users:sam:Desktop:newtargetinv.csv" as CSV
file format
Rather than "save in"
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"
openfile
"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
closewithout
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