Problem with a simple Excel 2004 script
Problem with a simple Excel 2004 script
- Subject: Problem with a simple Excel 2004 script
- From: Don Fuller <email@hidden>
- Date: Thu, 30 Aug 2007 20:41:13 -0500
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.
|
_______________________________________________
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