Saving file via Macro without being prompted

[David]

I have an excel worksheet where I want to save it's pages without being
prompted "X file already exists in this location, do you want to replace
it?" I want to replace these files without being prompted. The snipet of
the current VB code to save, currrently looks like this:

Sheets("1Week-2004").Select
ActiveWorkbook.SaveAs Filename:="C:\My
Documents\Baseball\1Week-2004.txt", _
FileFormat:=xlText, CreateBackup:=False

Thanks Much!
David

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***

 

[Frank Kabel]

Hi
try
application.displayalerts=false
Sheets("1Week-2004").Select
ActiveWorkbook.SaveAs Filename:="C:\My
Documents\Baseball\1Week-2004.txt", _
FileFormat:=xlText, CreateBackup:=False
application.displayalerts=True

 

[David]

Adding in the first part worked like a charm.

Thanks A bunch,
David

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins &
Software!http://www.ozgrid.com/Services/excel-software-categories.htm **