Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Browse button on form for folder path
Hi All
I am trying to create a form which has a button which can browse for a folder path. I then need to have this path placed in an adjacent textbox. I think I need something along the lines of the following in the command button's code: Application.GetOpenFilename however this piece of code just opens a file whereas I need the pathname for a folder. Any ideas out there would be greatly appreciated. Cheers, Mike |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Browse button on form for folder path
Jim Rech has a BrowseForFolder routine at:
http://www.oaltd.co.uk/MVP/Default.htm (look for BrowseForFolder) John Walkenbach has one at: http://j-walk.com/ss/excel/tips/tip29.htm If you and all your users are running xl2002+, take a look at VBA's help for: application.filedialog(msoFileDialogFolderPicker) Greshter wrote: Hi All I am trying to create a form which has a button which can browse for a folder path. I then need to have this path placed in an adjacent textbox. I think I need something along the lines of the following in the command button's code: Application.GetOpenFilename however this piece of code just opens a file whereas I need the pathname for a folder. Any ideas out there would be greatly appreciated. Cheers, Mike -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Browse button on form for folder path
Those were two excellent links and just what I was after.
Thanks for that Dave |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automate process via button on form | Excel Worksheet Functions | |||
use a button to open a user form? | Excel Discussion (Misc queries) | |||
display set of records in a form with previous and next button | New Users to Excel | |||
Command button on data-entry form | Excel Discussion (Misc queries) | |||
A "previous" button on a user form | Excel Discussion (Misc queries) |