Replace existing file with macro 1

[duncansancho]

I have a macro which having done it's job must save the file it has been working on as the same name and in the same location as it was before. At present it interrupts itself to ask if I want to replace the existing file. Is there a way to write something into the macro to do this automatically?

 

[RobBroekhuis]

use application.displayalerts=false right before the saveas command, and turn it back to true right afterwards.


Rob

 

[duncansancho]

Rob,
Thanks a million - it works perfectly!
Duncan