VBA - assign WB to new variable, save and close but keep previous variable open.

[RCBricker]

This is/was hard to put into words for a title and as such a search.

I have never needed to do this, but now I do so need some guidance.

I have a workbook that I am assigning to a variable. What I want to do is use that workbook like a template. I have to make 48 similar workbooks, but really only want the code to work once, then adjust based on the workbook it is currently on.

wbA has code that sets up all the various sheets, pulls in the data and organizes everything.

wbA is then saved as a new variable- lets say wbB, code then runs and makes adjustments to the various sheets including removing unwanted data. Save close.

Back to wbA rinse and repeat till down.

I am uncertain as to how to assign another variable to the existing workbook, save it and close it and yet still have the original workbook still open without the changes....

I am certain that I am missing something simple but anything you all can offer that will at least point me in the correct direction would be great.

thanks,

 

[Norie]

Are you actually creating new workbook at some point?

If you aren't then you can't do what you want.

 

[RCBricker]

yes wbB is supposed to be a new workbook. But I think the way I am thinking about it then I am not actually creating a new object.

 

[Norie]

Can you post what you have so far?

By the way, have you considered actually using a template?