removal of text box..

[Chris Dillon]

Hi folks...sorry for the cross post....I have a faculty member who's insistant
regarding this problem, and I'm at the end of my rope! Thanks..

Hi all..
I have a macro for a dual save feature and at the end a dialog box pops up
asking if I want to write over the existing file. Does anyone know what line
to put in the macro to eliminate this box?
Thanks so much,
Chris

 

[Ken Snell]

Can you post more details about the actual code steps you're using? If you
always want to overwrite a file, you can delete the original file using a
Kill command in VBA and then just save the file (no warning box); or you can
use the FileCopy method to overwrite an existing file; or you can use the
Name ... As statement to do this.