Thread
:
Default to SaveAs
View Single Post
#
1
Posted to microsoft.public.excel.programming
Bob Phillips[_6_]
external usenet poster
Posts: 11,272
Default to SaveAs
Why don't you check if the file exists, and rename it then?
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"John Reagan" <John
wrote in message
...
ActiveWorkbook.SaveAs Filename:="C:\" & final & ".xls",
FileFormat:=xlNormal, _
Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _
CreateBackup:=False
In the above statement can the default on the popup menu (A file named
'xxx' already exists in this location. Do you want to replace it?) which
appears when the file 'xxx' already exists, be reset to a default of "No".
When I use Application.DisplayAlerts = False the default for the above
command on the popup menu is "Yes" to overwrite the file - I want the
default to be "No" so I can rename the file under
VB
control.
Thanks
Reply With Quote
Bob Phillips[_6_]
View Public Profile
Find all posts by Bob Phillips[_6_]