Save As VBA

  • Thread starter Thread starter Roger R
  • Start date Start date
R

Roger R

How do I write the code to make it so the promt asking if
I want to replace an exsisting file when I "save as" does
not come up?

I tried to find the answer my self in the "help" and the
object browser, trying to break my dependency on this
newsgroup, but it's just a heck of a lot easier, and
faster to ask.

Thanks
Roger
 
Precede the code with

Application.DisplayAlerts = False

and reset to True after


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top