Force Save over existing file
 

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

Force Save over existing file
 

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

Force Save over existing file
 

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

Force Save over existing file
 

You can also use

Application.AlertBeforeOverwriting = False

Which leaves other alerts on
--
Tony Green


"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