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