disable pop up when overwrithing saved files
 

Beth

Application.DisplayAlerts = False
' your code
Application.DisplayAlerts = True

Regards

Trevor


"Beth" wrote in message
...
How do I incooperate code that will automatically save an
existing file and not prompt me with the pop up window
of 'A file named Invoice Report already exists in this
locatin. Do you want to replace it?.