Change set workbook name from User input

So, I am in the process of streamlining my at work excel tasks with VBA.

So, below I have set wb2 as "Workbookexample Master WE 08-18-2018.xlsx" which I use for one week, then the date part changes within the filename for next week.
I would like to read in the current wb2 file name and have the user be able to change only the date part of the file name and have wb2 equal the new file name the user updates too.
How do I code this, I know there is use of an Inputbox or
Can I use a file picker dialog box to select the file to work with for the new week to maybe update wb2 below.
Thanks

Please Login or Register  to view this content.

Thanks for the reply UnderscoreBadger, I think I understand where you a coming from.
Thanks

Does this look right for wb2 reference?

Please Login or Register  to view this content.

Is the workbook open?

If it isn't you could use Application.GetOpenFileName to have the user pick the file from a dialog and then open it

Please Login or Register  to view this content.

Thanks Fluff13, sorry for the delayed answer, that worked great!

Hi Norrie,

I will explore your code and decide which one works better for my situation.
I may come back with questions. I am starting to get in VBA and I believe I am following what you have presented.
Thanks