Insert file path into a cell with Browse button | File dialog box in Excel | Excel Off The Grid

★ Want to automate Excel? Check out our training academy ★

★ Download the example file★

★ About this video ★
In this video, you'll learn how to use the File Open window to get a file's path and enter it into a cell.

✉ Subscribe & get my 100 Excel VBA Macros ebook ★

★ Where to find Excel Off The Grid ★

#MsExcel #VBA #Automation

[tonyful]

Great!!! Now I can upgrade my dashboard with a new object!!! Thanks a lot

[madeehaali]

this is great. As someone fairly new (who wouldn't know ABC of visual basic)
I wish I could just copy paste the code for the macro.

[UpExcel]

Thanks Mark, good stuff 👍 It wouldn't take much extra code to set the default file path to the folder in the named range so the file dialog always opens at the previously selected location each time. You might need a bit of error trapping and text manipulation to remove the file name but would be neat.

[wayneedmondson]

Hi Mark. Awesome example! Well explained and easy to follow. Thanks for sharing :)) Thumbs up!!

[codyrozema]

Great video! I need to make a worksheet in which every row in a certain column lets you select a file. How can you apply this method to multiple cells?

[vkvivek]

Great Video.
Can you tell me the code to automatically link that file path to the particular file.

[theabundantstar]

Hi, Priya this side- thank you million tons! I was able to create a select file using the above technique. Yaay! Just one question to broaden my understanding- why did you use option explicit? Hoping for reply! Thank you so so much !!

[swapnilgupta]

Hi great video, but if we want to open that same file whose file path we are fetching in same workbook in which we have created button then, How will it be done ?

[rambotech]

i need ur help please i make upload button in user fourm but i have problem ( when i convert the sheet to user fourm the uplode sheeet when copy some data to other sheet its open the whorksheet in background how i hide this

[perrinms]

Is there a way to do this without using VBA? I have issues with my clients' security and xlsm workbooks.

[ArneilPhinn]

How do you change this to folder path only please ? Thanks

[mohamedhanafy]

Hi Mark. thank you for your explain this topic, but I want when I print any page in excel the file path appears automatically. Thank you advance

[garethmorrall]

How do you use this for multiple different file paths. All in Column S then want folder icons all in cell T next to my path. Thanks

[franciscovillalobos]

How can we open the workbook file we are selecting?

[bharmaldesignprintingphoto]

THIS CODE WOULD BE VERY USEFUL IF BY PRESSING ANY CHECKBOX OR RADIO BUTTON THE CODE WOULD EXECUTE AND THE CODE COULD BE COPIED TO BELOW LINES USING DRAG DOWN