overwrite
Thank you...cool.
Steve
"Bob Phillips" wrote in message
...
Application.DisplayAlerts = False
... code
Application.DisplayAlerts = True
--
HTH
RP
(remove nothere from the email address if mailing direct)
"SP" <none wrote in message ...
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
|