Using SaveAs

[Guest]

I want to save my workbook using VBA. I wnat the open workbook to be saved in the same directory where it is residing. How do I complete the following?

Application.ThisWorkbook.SaveAS

 

[dk]

The fact that you say that you want to save the workbook in the folder it is currently residing would imply that the workbook has been saved. Therefore, just use this:-

ThisWorkbook.Save

If you want to create a second copy then use:-

ThisWorkbook.SaveAs ThisWorkbook.Path & "anyoldname.xls"

HTH,
D

 

[Guest]

Thanks DK. Just what I was looking for.

Stan