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!

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)

" wrote in
message ...
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!

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)

"
wrote in
message ...
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!


.