Excel macro - Save as with override...

[hakanmalmros]

I am trying to handle "save as" command with override
of "File already exist, Do you want to replace it" from
excel VB macro but I can't get it right.

Using "ActiveWorkbook.Close Savechanges:=Active,
Filename:="C:\Test1.txt", FileFormat:=xlText,
CreateBackup:=False"

Can not find any argument to override xl messagebox.

Thanks!

 

[Bob Phillips]

Application.DisplayAlerts = False

before, and reset to True afterwards

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Guest]

Thanks!
Works just fine !!!

-----Original Message-----
Application.DisplayAlerts = False

before, and reset to True afterwards

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"(e-mail address removed)"