overwrite

  • Thread starter Thread starter SP
  • Start date Start date
S

SP

Hi

ActiveWorkbook.SaveAs newfilename

If newfilename already exists at the saving location, a prompt will pop up
to confirm overwrite. Can I say Yes through the codes instead of manually
clicking on the Yes button ?

Thanks
Steve
 
Application.DisplayAlerts = False
.... code
Application.DisplayAlerts = True

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Thank you...cool.

Steve

Bob Phillips said:
Application.DisplayAlerts = False
... code
Application.DisplayAlerts = True

--

HTH

RP
(remove nothere from the email address if mailing direct)
Click to expand...
 

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

writing excel data into word document 1
Catching duplicate filenames when renaming a file 3
Advice & Error Trapping 3
help renaming file 2
Save e-mail to .msg file 4
UserForm and ordering variables 3
Overriding the overwrite confirmation prompt 2
Copy Visible Sheets into one Workbook 3

Back
Top