Look for and Open saved workbook retrieve information into new WB then close them

Hello All,

Ok Have another issue maybe some in here could give me a hand or point me in the correct direction.

Back ground:
1. With the help of this forum I have finished the original project of creating an inventory Workbook (will attach a sample) that I will attach to help you understand.

2. Now when this workbook is opened it requires the User to enter information in Two field and those are used to help set the file name and once they are done with the inventory it is saved onto the Server

3. This is done on 4 different Trucks bye 4 different people on a monthly schedule. So each month there will be 4 new outdate inventories on the server in their own file folder.

What I need now:
1. So I need a Code that will look into 4 different Folders look for the Newest File (by its date) show the dates in the appropriate slots of the Inventory Pull Workbook. (Attached a sample of the Pull workbook).

2. Once the 4 Newest books are listed in there appropriate slots, a Second Button is pressed to open said files and Copy the files to Inventory Pull workbook to appropriate Sheets (Sheet2) and again the different Colum’s for each File.

3. File Location for folders is:
C:\Users\Brian\Desktop\Excell test folder\1903
C:\Users\Brian\Desktop\Excell test folder\1904
C:\Users\Brian\Desktop\Excell test folder\1905
C:\Users\Brian\Desktop\Excell test folder\1908



Aeneren

Hello All,

Ok havent gotten a nibble on this yet so ill try asking for alot less

can anyone give me a hand on Any part of my original post

Aeneren

Nilem,

Thanks for your input, tried your sample and it did pull dates from test folders i have set- up and im working on the copy paste portion now will get back with you in couple days with results if not sooner.

Now, to deciver your code to a Novice level of understanding

Thanks again
Aeneren

Nilem,

Ok Finally had some down time at work to take a look at your coding
I was able to get your code to work with your WB that you posted but soon as i transferd it to my full WB it will not work.

I've looked it over with no luck, Any chance you can give this Novice a hand again.

Thanks
Aeneren

Step 1, ver. 2. Try

Nilem,

Thank you again. pulled your WB and Code over and it is working as intended.

Now onto the Second part of this Task.
Once all the inventories have been verified to be done by the use of the Code you wrote, Now to use the File Paths your Code shows to Open, Copy Column C of 30+ Sheets and Paste those into Sheet 3 into Column A.

Thanks Again
Aeneren