| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Browse Window
Hello all,
Could anybody help me regarding the following issues. I am writing a VB macro in XL where I need to select a folder by clicking on the Open button, created by me. I should be able to browse my computer to select a folder and retuen back to my xl sheet with the selected folder path. Then if I press Execute, it should execute the DOS command dir /s files. xls to get all the files including its sub folders in to an xml file. Then I will apply some simple logic to meet my requirements. Could anybody provide me the VB code for the following activities. 1. VB code to open a new browse window where I can select a folder and this path is returned back to text box. 2. A way to invoke the command prompt from VB macro to execute the command dir /s files.xls Thanks Sri -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200810/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trying to browse Add-ins???? | Excel Discussion (Misc queries) | |||
| View cell contents as a pop-up window (similar to comments window) | Excel Worksheet Functions | |||
| Docking Project Explorer, Properties window and Code window in VBE | Setting up and Configuration of Excel | |||
| The window opens in a smaller window not full sized window. | Excel Discussion (Misc queries) | |||
| Excel 2003 Viewer: No more "Browse in same window" IE functionality? | Excel Discussion (Misc queries) | |||
Threaded Mode
