I am trying to create a user form that will list all the vendor folders, sub folders and files. I have already created a button that allows the user to pcik the vendor folder location, there is also a TextBox linked to the Browse button that shows the folder file path.
The problem I am having is getting the Mfg folders, sub folders and files listed in my ListBox.
What I am trying to do would look something like this
J:\Shared\Engineering\Electrical\Vendor Info <<<<Vendor folder path
Vendor Info <<<<Main folder
--------------AB <<<<Mfg folder
---------------------1492-IFM <<<<Sub folder
----------------------------1492-IFM20F_MULTIPLE.pdf <<<<File
--------------20-COMM-E Ethernet IP Adapter.pdf <<<<File
--------------ABB <<<<Mfg folder
---------------------Circuit Breakers <<<<Sub folder
----------------------------TMAX Series <<<<Sub folder
------------------------------------TMAX frames sizes 1-8.pdf <<<<File
This would be in "ListBox1" the user then could select the desired files click the move files to "ListBox2" button.
everyting in "listBox2" could then be copied out to a second user defind location once the user submits their file selection.
Here is what I have so far.
Vendor list.xlsm
I have been looking for an answer but have not been able to find anything.
Thank you for the help.
Bookmarks