Macro Command

[Edmund]

I'm trying to write a macro that opens a blank
spreadsheet, then saves it as a particular name, in a
particular place. It's all good except when I run the
macro it always asks me if I would like to replace the
exsisting file. What is the command to always say "yes"
to that prompt?

Thanks

 

[Peter Atherton]

-----Original Message-----
I'm trying to write a macro that opens a blank
spreadsheet, then saves it as a particular name, in a
particular place. It's all good except when I run the
macro it always asks me if I would like to replace the
exsisting file. What is the command to always say "yes"
to that prompt?

Thanks
.

Edmund

Try

application.displayalerts=false

place this before the save command

Peter