Macro Command

  • Thread starter Thread starter Edmund
  • Start date Start date
E

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
 
-----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
.
Click to expand...
Edmund

Try

application.displayalerts=false

place this before the save command

Peter
 
Back
Top