Response to menu in VBA
 

Hi,
I have macros which save the file name "temp.xls" which already exists. I
want the
macro to replace the existing file without waiting for the user to input a
response.
How do I write this in VBA ?
Thanks in advance,
Rocco

Response to menu in VBA
 

Application.DisplayAlerts = False
ActiveWorkbook.SaveAs FileName:="temp.xls"
Application.DisplayAlerts = True

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Rocco" wrote in message
...
Hi,
I have macros which save the file name "temp.xls" which already exists. I
want the
macro to replace the existing file without waiting for the user to input a
response.
How do I write this in VBA ?
Thanks in advance,
Rocco