Excel VBA Excel 2000

[KenReay]

Hi

I am trying to save a workbook in VBA

oWs.SaveAs etc does the job if the file does not already exist, but how do I save it when the file does exist without receiving a warning message?, I would have thought it was simple as oWs.Save, but this gives a compile error saying method not available

Thanks

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[SkipVought]

Hi,

If you just want to overwrite...

Application.DisplayAlerts=False
...
"save file
Application.DisplayAlerts=True

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[KenReay]

Hi

Thank you! that did it

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[xlbo]

From excel help - saveas method:

Filename Optional Variant. A string that indicates the name of the file to be saved. You can include a full path; if you don't, Microsoft Excel saves the file in the current folder.

so:
ows.saveas

without a path should perform a save in the folder that it has been opened from

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244