overwrite
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 |
overwrite
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 |
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 |
All times are GMT +1. The time now is 05:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com