| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
File Browse Box
I have a userform on my sheet. What i want is a command
buttom to bring up box which will enable me to browse files on my hd and then select one to perform an action on. Does anyone know how to do this? Also can you have the default value pointing to a specific folder? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
File Browse Box
See the Application.GetOpenFileName method. This will display a
standard File Open dialog box and return the complete path of the chosen file. It does not actually open the file. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "JONNIE" wrote in message ... I have a userform on my sheet. What i want is a command buttom to bring up box which will enable me to browse files on my hd and then select one to perform an action on. Does anyone know how to do this? Also can you have the default value pointing to a specific folder? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
File Browse Box
Chdrive "C" Chdir "C:\Myfolder" fName = Application.GetOpenFileName() -- Regards, Tom Ogilvy "JONNIE" wrote in message ... I have a userform on my sheet. What i want is a command buttom to bring up box which will enable me to browse files on my hd and then select one to perform an action on. Does anyone know how to do this? Also can you have the default value pointing to a specific folder? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Browse For a File or Path and enter in a cell | Excel Discussion (Misc queries) | |||
| Browse File for Mac | Excel Discussion (Misc queries) | |||
| can't browse file | Excel Discussion (Misc queries) | |||
| Browse Button for File Save | Excel Programming | |||
| Import File with browse and select (even from Pocket PC?) | Excel Programming | |||
Hybrid Mode
