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)


"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

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