finding a reference workbook

jkicker

Board Regular
Joined
Jun 7, 2018
Messages
77
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
 

Some videos you may like

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
52,974
Office Version
365
Platform
Windows
You are welcome.
I have used this a few times myself.
 

Watch MrExcel Video

Forum statistics

Threads
1,095,371
Messages
5,444,064
Members
405,265
Latest member
Iram

This Week's Hot Topics

Top