I have a Save as macro but I need to keep the original open at the same time

[thedon_1]

I have a macro that saves my currently open file in a specific location and with a specific name based on certain conditions in a cell but i want the original file to be open at the same time.

My end goal is to have an open book with a load of data, copy the whole workbook (I don't know how to do this), make any changes (e.g. delete a couple of rows-I can do this) and then save as an xlsm (I have code to do this) and finally close the book. Then the only open book would be the original with all the data. I would do this multiple times based on what data is deleted (e.g data with multiple names, I would have one version for each name).

The only part I cannot do so creating a copy of my current workbook to make arrangements.

Here is my code to save the file.

Please Login or Register  to view this content.

Thanks

[Domski]

Have a look at using SaveCopyAs rather than SaveAs.

Dom

[thedon_1]

That does the job of saving another copy, but how do I open it to make changes and then save?

[Domski]

Please Login or Register  to view this content.

Will take a copy of all the sheets into a new workbook you can then just work on that and save it.

Dom