How do I assign a Variable name to a workbook?

[brockvilleal]

I am working in one workbook and would like to assign it to a variable name so that I can open that same workbook later on. I know in which folder the file is located but when the file gets saved, it uses that day's date in the filename. So, how do I open that file with the changing name? I believe I need to assign the file to a variable name but there may be other ways of doing this.

 

[RalphA]

Perhaps you can save your workbook under its current name, then do a File, Save As, and save it with a new name. Now, you have two, identical files, with different ames. Is this what you are after?