| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
User dialogue to browse folers
I'm trying to modify a VB6 program (macro) that can run a user dialog, allow
the user to browse the network to find paths, and then, having selected one, pull the path string back into my macro. I have found documentation on the Shell function to do this, but it's not a command that's supported with VBA that I have. Is there a straightforward way to do this in VBA from an Excel spreadsheet? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
User dialogue to browse folers
Not sure if you are using VB6 or VBa but this works in both:
http://vbnet.mvps.org/code/browse/browsefolders.htm NickHK "rcrosby" wrote in message ... I'm trying to modify a VB6 program (macro) that can run a user dialog, allow the user to browse the network to find paths, and then, having selected one, pull the path string back into my macro. I have found documentation on the Shell function to do this, but it's not a command that's supported with VBA that I have. Is there a straightforward way to do this in VBA from an Excel spreadsheet? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trying to browse Add-ins???? | Excel Discussion (Misc queries) | |||
| How can I make a dialogue box pop up with a notice to user? | Excel Programming | |||
| Enable/Disable Macros dialogue box when user opens Excel | Excel Discussion (Misc queries) | |||
| Le dialogue de fonction d'excel appel ma fonction "user defined" | Excel Programming | |||
| User functions and the Insert-Function dialogue | Excel Programming | |||
Linear Mode
