Posted to microsoft.public.excel.programming
|
|
Excel macro - Save as with override...
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!
.
|