Hello
I am using excel 2003 and have created a worksheet with macros which allow users to enter data for a period of time. When the period has finished they click a button which validates the data and updates a sql server database. Then we go thru a process of saving a copy of the workbook on a network drive (workbook saveas), clear the relevant cells and prepares it for the next period and then save the workbook back in the original folder for the next period.
I save the workbook using saveas again but this time using the original filename captured earlier but i dont want the user to be prompted to replace the file. How do i stop this prompt from appearing???

Any ideas/suggestions

Thanks

GuyB

Set the display alerts to False. This will stop the prompts

Application.DisplayAlerts = False

' Your Save Code here

' Reset the Alerts
Application.DisplayAlerts = True


http://www.vbadud.blogspot.com

Thanks

worked like a charm

GuyB