I have been dealing with this problem for some time now and I still can't figure out what I need to do for this LOOP.
In the excel program, I have code that allows you get data from a certain excel file in a certain folder on the hard drive (depending on what month/year and state, which is all based off the file name), that data is then added into the correct excel sheet. Anyways, we finally decided that it is too much of a hassle to do each file individually and now would like to get ALL of them at once.
So instead of doing the certain search for month/year and state, I would like to replace it with a GET ALL, and just find every file with the name ending in "RI-XML.xls" and LOOP until all of the files in that folder (with that name) have been added. I think a LOOP would be the best option, however mine never works.
I attached my MAIN DATABASE with the code to retrieve data, along with some sample files were data is pulled from. You will need to put all of these in C:\temp on your hard drive for it to work without changing code.
Thanks for taking the time to read everything, if you need anymore info, ill try to get it you ASAP.
THANK YOU!! -- CINDY