Excel can I save with replacing

Scripting Forums AppleScript | Mac OS X
#1

I don’t seem to be able to do the equivalent of a ‘save with replacing’ in Excel so that I don’t get a confirm dialog.
Any workarounds (other than deleting a file with the same name first)?

#2

Hi,

is

close saving yes

an alternative?

#3

Hi StefanK
thanks for replying.

Trouble is when I do that and there is an existing file of the same name I get the confirm replacing dialog, which I want to avoid since this is a robot system.
What I want is the equivalent of the Finder’s ‘with replacing’ that suppresses the dialog: Or else something like, say, InDesign’s ability to turn off or limit all dialogs.

rhb

#4

if you open a file, change something and save it with

close active workbook saving yes

there is no dialog.

Or you could check and delete the existing file if necessary