Re: Excel Save as text question
Re: Excel Save as text question
- Subject: Re: Excel Save as text question
- From: Stan Cleveland <email@hidden>
- Date: Wed, 20 May 2009 14:24:16 -0700
- Thread-topic: Excel Save as text question
On 5/20/09 1:17 PM, "Oakley Masten" wrote:
> Unfortunately, it still does not overwrite.
> It asks if I want to and when a choose ³yes² it continues with the script but
> does not overwrite.
> I don't want it to even ask. I tried adding an "ignore application responses"
> but that cause the script to stop working.
>
> I guess the most workable answer is still to check for the existence of the
> file and delete it before saving.
> This was suggested by Yvan KOENIG (from FRANCE)
Hi Oakley,
Yvan's suggestion is a good one. Be aware that System Events won't delete a
file that is busy (open in an app) and, unfortunately, neither will it
generate an error in that case. It just silently skips over the command. (In
OS X 10.5.7, anyway.)
The Finder, however, doesn't seem to care* and will dutifully move a busy
file to the trash. (I usually prefer System Events over the Finder, but
obviously not in this case.)
I do have another suggestion for you--upgrade to Excel 2008. The "save as"
command in 2008 has an "overwrite" parameter that functions as expected.
HTH,
Stan C.
*Don't anthropomorphize computers. They hate that!
_______________________________________________
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