Hi,
Is there an elegant way of saving the current workbook as a new file in a specific location, without it becoming the new saved as workbook? I want a copy placed in a specific location but the original file must be kept active. Alternatively, save as, close the new saved workbook and reopen the original workbook; however this way stops the code execution which was in the original file (since it is now closed).
TX
Excel VBA Save As without leaving current Workbook
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Excel VBA Save As without leaving current Workbook
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- Administrator
- Posts: 78230
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Excel VBA Save As without leaving current Workbook
The Workbook has a SaveCopyAs method:
Code: Select all
ActiveWorkbook.SaveCopyAs "C:\OtherFolder\OtherFile.xlsm"
Best wishes,
Hans
Hans
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: Excel VBA Save As without leaving current Workbook
Nah....
As simple as that!!!!
TX
As simple as that!!!!
TX
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.