Code to automatically overwrite?

[andycharger]

I need to save my spreadsheet as part of my macro. The trouble is, th
worksheet already exists. How can I automatically get my sheet t
overwrite?

This is what I was using:
[vb]
ActiveWorkbook.SaveAs Filename:="C:\LEXPM1a.xls"
FileFormat:=xlNormal, _
Password:="", WriteResPassword:="", ReadOnlyRecommended:=False
_
CreateBackup:=False
[/vb

 

[Pete McCosh]

Andy,

enclosing the code to save the file in the statements:

Application.DisplayAlerts=false
....
Application.DisplayAlerts=true

will suppress the replace file pop-up.

Pete.

 

[Bob Phillips]

Andy,

Haven't tried your code but do not see any obvious problem. Have you tried
it and get a problem?

Only couple of points I would add is that you can remove all of the
extraneous arguments, such as WriteResPassword, they are all defaults, and
you might want to precede the code with Application.DisplayAlerts = False,
so as to avoid the warning message. Remember to reset at the end.


--

HTH

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