I have a macro that, among other things, saves a worksheet with a
specific name. Everytime the macro is run I get the standard dialog box
"do you want to replace the existing file". I am looking for away to
replace the file without the dialog box popping up, so the user won't
have to interfere.

Thanks in advance,

Jasper Blaas


--
JasperBlaas
------------------------------------------------------------------------
JasperBlaas's Profile: http://www.excelforum.com/member.php...o&userid=12615
View this thread: http://www.excelforum.com/showthread...hreadid=400776

application.DisplayAlerts = False
' code that causes prompt
Application.displayAlerts = True

this works.
--
Regards,
Tom Ogilvy

"JasperBlaas"
wrote in message
...

I have a macro that, among other things, saves a worksheet with a
specific name. Everytime the macro is run I get the standard dialog box
"do you want to replace the existing file". I am looking for away to
replace the file without the dialog box popping up, so the user won't
have to interfere.

Thanks in advance,

Jasper Blaas


--
JasperBlaas
------------------------------------------------------------------------
JasperBlaas's Profile:
http://www.excelforum.com/member.php...o&userid=12615
View this thread: http://www.excelforum.com/showthread...hreadid=400776

hi,
Try this. it will turn off the message will saving but be sure you turn
alerts back on.

Application.DisplayAlerts = False
ActiveWorkbook.SaveAs " "filepath\filename""
Application.DisplayAlerts = True

regards
FSt1

"JasperBlaas" wrote:


I have a macro that, among other things, saves a worksheet with a
specific name. Everytime the macro is run I get the standard dialog box
"do you want to replace the existing file". I am looking for away to
replace the file without the dialog box popping up, so the user won't
have to interfere.

Thanks in advance,

Jasper Blaas


--
JasperBlaas
------------------------------------------------------------------------
JasperBlaas's Profile: http://www.excelforum.com/member.php...o&userid=12615
View this thread: http://www.excelforum.com/showthread...hreadid=400776