Hi XCESIV,

Try:

Application.DisplayAlerts = False

'Your save code

Application.DisplayAlerts = True


---
Regards,
Norman


"XCESIV" wrote in
message ...

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