Okay, so I have quite a few scenarios where I am needing within my macro to activate multiple workbooks.

These workbooks are often named different names, including one of which I use regularly that is a template, so every time it opens, it has a number at the end of it.

I had an epiphany that if there was a way that I could get excel to assign a variable name to an active workbook so that later in the code, it is able to go back to that workbook that is no longer active now because it has moved on to other workbooks since then, that would make life a whole lot easier.

I googled a bit, but all I could find was code that activates workbooks.

So in a nutshell, I am not needing a code that can activate a workbook. I need a code that can sort of grab whatever the name is of the current active workbook and allow me to use that later.

Any ideas?