Changiing defaults in VBA

  • Thread starter Thread starter JohnUK
  • Start date Start date
J

JohnUK

Can anyone help me with this one - I need a code that
over writes the defaults when saving a document. For
example, when opening a workbook from one location and
saving into a different location with a file with the
same name, I need it to save without the "This file
already exists, do you want to replace the existing
file?" The default is set to NO, but I need it to be YES
Many thanks in advance
John
 
Precede with

Application.DisplayAlerts = False

and reset afterwards.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
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

Save as default Excel 2007 4
Changing Defaults in VBA 2 1
Save to a location other than default 6
Excel template location 1
Changing Defaults in VBA 3
Macro to push data to another workbook 0

Back
Top