finding a reference workbook

[jkicker]

I am creating workbook1 that needs to take data from workbook2. The problem is that the file location of workbook2 sometimes changes, or paths are renamed, or on a yearly basis the name of workbook2 might change. I would like to circumvent this problem with a dialogue box/input box that gets the user to show Excel the filepath by clicking through folders, finding workbook2, and hitting a button to select the file, in the same fashion as if you were opening workbook2. Is there an OpenFile command or something similar or just any way to accomplish this? TIA

 

[Joe4]

Have a look here: https://www.mrexcel.com/forum/excel-questions/941732-vba-macro-ask-user-browse-excel-file-open.html

 

[jkicker]

Thank you Joe this looks like what i'm looking for!

 

[Joe4]

You are welcome.
I have used this a few times myself.