Excel VBA Basics #28 Get the Name or File Path, Open File Browser in VBA

Fantastic Developer Tools:

[ExcelVbaIsFun]

AJ Christon, I agree! I'll have to try and remember to do that. Granted, the code changes as the videos progress. Did you know I'm offering the workbooks from the tutorials FREE so people can use, learn or adapt them to their own projects. I'll add the links to this video. Thanks for watching! Dan

[m.n.]

hi thanks for the vedieo/// is that work for mac olso to fined path of files in mac? how can i write a file refference in excel vba for mac?

[ExcelVbaIsFun]

Merry Christmas everyone. I hope God blesses you richly this upcoming year. Remember, you ARE a success!! Believe it, be it! Blessings my friends!! Dan

[Branchiesthlm]

Hi Dan!

I need to do this for every file in a folder. Basically making a list of the files in that folder. Any tips on how to do that?

Many thanks // Fred

[daniellarsson]

Just what I was looking for, thanks Dan!

[DeeDawg]

Happy New Year sir. Do you have a similar video that shows how to have a user input form appear, have the majority of the file path appear already filled into the box, then prompt the user to fill in a variable (such as their username)? Once the user inputs the user name, the file then opens? For example- C:\Excel\user1\test.xls where the input box prompts the user to input their particular username, i.e user2, user3, etc. Once they enter their username, the file opens.

[lynnettehornung]

I have been learning a lot from each tutorial, so thank you. Unfortunately with this lesson I'm not having any luck. Any time I hit F8 my computer makes a sound and if I hit F5, it brings up the macro list which doesn't include this one. What am I missing?

[RTJDCosplay]

Hello im wondering if u can help, im looking to keep a log of all of my files with a speficic name, i dont need to search for each one,

Is there anyway i can
CLICK BUTTON>ACTIVATE MACRO
serch files ENDING ".stl"
And then it lists ALL files ending with that extention JUST THE NAMES i dont need the extention (c://... ect.)

[imyong]

How to show only the file without the file location?

[Ryff]

Hi Dan, i need to open source file with this macro, and open it in my current sheet, like a copy paste but file location being on another computer....how can i do that?

[mxdogg]

It would be awesome if you would post the code you write during the video in the description!

[iKrromz]

Thanks!! How can I make the link clickable?

[latinodx]

Helo Dan, I really appreciate your strong support for providing us will all this information that has been vital in my dailywork

I recently came across a situation in which I would like to open a file when i select a name in the combobox... can you please assist?

Thanks in advance.

[muneebkhan]

Dear Sir
Can you help me to Draw Cross Section of Road from Excel file to Autocad Pleas?

[Donnee]

Only 8 years late but how do you get multiple file paths?