Paste a path after a command button instruction to open

[Andresleo47]

Hi, I have an Excel file and I have created the attached Command Buttons and Text Boxes. The "Active Contractors File" button opens a box where a file can be selected. I would like the file path selected to be copied in the first Text Box. Same thing for the second one.

After that, when I click the "Open Working File" button, I would like the 2 files to be opened in a new file in 2 different sheets.

Any thoughts or ideas? I would appreciate the brainstorming.

Thanks!