[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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
Delivered-to: email@hidden
Delivered-to: email@hidden

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:
http://lists.apple.com/mailman/options/applescript-users/email@hidden
Archives: http://lists.apple.com/archives/applescript-users

This email sent to email@hidden

Follow-Ups:
- Re: Problem with a simple Excel 2004 script
  - From: Don Fuller <email@hidden>

Prev by Date: Re: XML - System Events vs XMLlib
Next by Date: Re: XML - System Events vs XMLlib
Previous by thread: Mac Mail does not work as I want :)
Next by thread: Re: Problem with a simple Excel 2004 script
Index(es):
- Date
- Thread

Home