Open Folder (Prompt User for final folder name in location path)

Hello,

I'm having a little difficulty creating this macro. I know how to open a folder, and I know how to open a file from a folder...


...but what if I want the user to click a button to active the macro, then they are prompted to enter in the final folder name of the folder he/she wishes to open through the use of a pop up?

I assume that I first need to create a UserForm1 with the text field for the user to enter the exact name of the folder, and a button to proceed.

Untitled.png

Steps:

Sub()
Click button
Prompt Opens
User enters folder name
Selects button to proceed
Macro Opens Folder ("Network path \" + folder name "\"
Window folder
User can double click on excel file to launch.
End sub

Originally Posted by xlbiznes

Hi,
why dont you use the inputbox command.

like this :

Please Login or Register  to view this content.

That would work, not sure how to incorporate it. Might have to google it.