vba for save as file to specific folder and close that file, but keep original file open.

Hi ,

Hoping someone can help?

I have a macro enabled file named as "tax invoice" and need a macro to "File Save As" to specific location for example in "C:\Users\Store\Desktop\Tax Invoice" with specific cell value i.e. "M7" which has Invoice No. in it & close the save as file but keep original "tax invoice" file open for another invoice entry & so on.

I have tried few macros but they close the original file.

My aim is to keep original file open for another invoice entry.

thank you.

I am attaching same file for reference.

There is no VBA code to directly do what you are asking for.
You have to do this in few steps:

1. Create new workbook
2. copy your existing sheets in your tax invoice file to newly created workbook
3. save newly create workbook as (ActiveWorkbook.SaveAs)
4. close newly created workbook

To the best of my knowledge this is the only possible way of doing this.


Just realised something - why do you need to close this file at all? Is there any reason for this?

I take printout of saved as file with invoice no. So I did not have any use after that.
I make about 10 invoices a day, so I want to keep open the Original file instead of opening it again and again.

thanks

Well… you could update your workbook to capture code in 'Workbook.Save' subroutine and modify it's name there based on the content of the cell? That way, every time you'd press Save you'd end up saving new file with name based on the content of your cell?

You can use Savecopyas instead of Saveas.

it save the file, but with no extension. for ex. only 1, and not with 1.xls
so it could not be open.