Using VBA, there is a quick and easy way to obtain the file path of a file and return it to a sheet

• Use GetOpenFileName
• This brings up a dialog box that allows you to browse your files and choose a file
• You can then use that file path how you want

Here's a screen shot of our setup in Excel:

When we press the button, we get this:

Once a file is selected, and "Open" is pressed, we can use the file path... in this case, we put it in a cell.

Here's the code we use to get the file path:

Explanation:

1. GetOpenFilename allows you to enter the type of file you want to look for
2. The Open File dialog box then appears with only the desired file types showing.. (In our example, we look for text files)
3. When you choose one and press Open, it goes to a variable
4. If you press cancel, GetOpenFilename returns FALSE, so you need to check for that
5. You can use that file path as you want

Download sheet to practise how to Get A File Path in Excel

Training Video on how to Get A File Path in Excel: