This is such a simple question, but I cannot do it. And there are tons of great posts, but I can't apply them for some reason.
I have a folder called Reports.
In the folder I have subfolders called A, B, and C.
In each subfolder, I have an excel file named Years.
The Years files are all set up the same (two columns of data, first column is Company Name (A, B, or C, depending on the folder) and second column is Products (simple numbers)). I want to upload the same data from each file (Company Name and Products).
I want to write a load script to upload the Years file from each of the three subfolders.
What should that look like? I was going the SUB DoDir(Root) method, but then got mixed up with a file list of subfolders.
Ultimately, I'll need about 45 files pulled from each of the 75 subfolders, but I want to get this simple set up completed first.
Any suggestions appreciated. Thank you.
