disable pop up when overwrithing saved files
 

Use

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


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"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?.