open Window explorer from Excel

[Chris Baluyot]

Hi, Is there a way to open the Window Explorer to capture the full file path and name of the selected files from excel userform.

I have a userform that requires the user to enter the full file path and name of the workbook that they need to work with. It would be nice if they dont have to enter this but just use the window explorer to point out the workbook or text files.

Any help is very much appreciated.

Thanks.

[mudraker]

Here are a few methods

Please Login or Register  to view this content.

You can also use ther ChDir command

Please Login or Register  to view this content.

[Chris Baluyot]

Mudraker,

Thank you very much!. you're Awesome

My user would love this code. Can't thank you enough.

[mudraker]

thanks for the feed back