ON Wed,
13 May 2009
Ed Stockly,
wrote
Subject:
Re: Excel Save as text question
>Try
this:
> set myFile to ((targetFolder as text) & Excel_txt_FileName)
> save as worksheet 1 filename myFile file format text Mac file format
>with
overwrite
>There
is a difference in Excel between the 'save in' command and the 'save
>as'
command. One difference is save in does not have an overwrite parameter
>but
save as does.
>HTH,
>ES
Thanks
Ed,
I
appreciate your help.
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)
Thanks
Yvan,
I will try that next.
Oakley