Apple

On Aug 30, 2007, at 8:41 PM, Don Fuller wrote:

I have been pounding my head over this one for a couple of weeks. I've been playing with it a few minutes a day. I am simply trying to drop an .xls file on my script and have it save the dropped script in the same directory as the original as a .csv file. Sounds simple right? Well this script works the first time around, sort of. It will do exactly that, except the resulting .csv file is empty. If I run it again, it tells me that 'active workbook' doesn't understand the 'save' command. I don't understand… Can someone help?

Here is the script:

on open fileList
repeat with aFile in fileList
set aFile to (aFile)
tell application "Microsoft Excel"
open aFile
save ActiveWorkbook in (aFile & ".csv") as CSV
end tell
end repeat
end open

Thanks in advance.

--begin script

on open fileList

repeat with nextFile in fileList

tell application "Microsoft Excel"

open nextFile

set outFile to ((nextFile as text) & ".csv")

save the active workbook in outFile as CSV

end tell

end repeat

end open

-- end script

Thanks to Jolly Roger on comp.sys.lang.applescript

References:
	>Problem with a simple Excel 2004 script (From: Don Fuller <email@hidden>)