Create list of files from windows explorer folder

Hello all!

I am new at VBA, so any help is much appreciated. Here is a summary of what I'd like the end result of this project to be:

• When I open Workbook A, Macro #1 automatically runs as the file is opening.

• This macro will analyze the contents of the "Seed Folder" (through Windows Explorer) in order to come up with an updated list of all the seed files that are completed. This needs to happen each time as people open the Widget because our database of seed files will continue to grow as we document more processes.

• The list is in a scrollable format. Ideally, the user could scan through the list/drop down menu with the scroll wheel of their mouse, instead of only being able to sift through it by clicking and dragging the scroll bar up and down.

• After the user selects a topic from the list, they click the “Execute” button, which houses Macro #2.

• This macro will search through the Seed Folder and open the file that matches the user’s topic selection, in the background. Then, it will transfer the content from each tab in the seed file to the respective tab in Workbook A (tabs will have the same name). Once complete, the macro will close the seed file and direct the user to the "Overview" tab of Workbook A for their starting point.

• Macro #2 will also make a separate History workbook, in the background, each time a user clicks the “Execute” button. It will create a table that pulls the following information:

• User’s username

• File name

• Day and month accessed

• An added bonus would be if the macro could create a bar graph showing how much each file was accessed on a monthly basis.

Hopefully that all makes sense! Even if you can only provide a bit of code that does a portion of these requests - it would make my day! I have attached example files for your reference.

Thanks folks.

- Econ


Workbook A.xlsx
Seed File.xlsx