hi.
add this to your macro before the save as command...

Application.DisplayAlerts = False

then be sure to turn alerts back on after the save as.

Application.DisplayAlerts = True

regards.
FSt1


"XCESIV" wrote:


I have a macro that i have made that saves to a temp file. I want to
set the macro to automatically save to this file regardless if the file
already exists.

I have had a play with it and search on here and couldnt find the
anser.

Can someone please help.

Ty


--
XCESIV
------------------------------------------------------------------------
XCESIV's Profile: http://www.excelforum.com/member.php...o&userid=24271
View this thread: http://www.excelforum.com/showthread...hreadid=545355