removal of text box..

  • Thread starter Thread starter Chris Dillon
  • Start date Start date
C

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
 
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.
 
Back
Top