ActiveWorkbook.SaveAs Problem

[SowBelly]

Hello:

I am using ActiveWorkbook.SaveAs "filepath\filename" and it is working
just fine the first time around. Every time after that I get the Excel
MsgBox that informs me that the filename already exists and do I want
to overwrite. Since I have about 1300 files to do this with, I would
prefer to be able to force the ActiveWorkbook.SaveAs with no MsgBox.
Is it possible or do i have to test for the file first and delete it
before doing the SaveAs?

"Pigs can't be humans, but humans can be Pigs!"

Eating at the trough of life.

Oink!

SowBelly

 

[kevan hanson]

Application.DisplayAlerts = False

should work.

Regards
Kevan

 

[Norman Jones]

Hi SowBelly,

Try:

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

 

[SowBelly]

Norman:

Worked great!

SowBelly

Hi SowBelly,

Try:

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

 

[SowBelly]

Kevan:

Worked great!

Oink!

SowBelly

Application.DisplayAlerts = False

should work.

Regards
Kevan