Change ActiveWorkbook Save to Save As

route217
route217 used Ask the Experts™
on
Hi Experts

How would you change the current macro that saves the Active.Workbook to a save function and data stamp the save file..

Currently:

.ActiveWorkbook.Save

Waht to change to

.ActiveWorkbook.SaveAs xl Path = "\REPORT_1_" & Format(Now(), " dd-mmm-yy") & ".xls"

I believe the above is not correct....
Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
The parameter is
 Filename:=  
not
xl path =
route217Junior

Author

Commented:
Many thanks Peter..
route217Junior

Author

Commented:
Hi Peter57r

Can you kindly assist on this one;

http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_27680984.html

thanks

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial