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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

macro events 5
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
export query to excel macro 4
Auto Confirmation after running update query 1
Getting a macro to answer a dialog box automatically? 1
Set the value of a combo box 5
Importing dialog box 3
suppress macro messages 1

Back
Top