Hello Everyone,
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

Could you do something like this? (This is modifed code I found on the net)

I use a loop with Dir() for this kind of thing, but I've used FileSerach in the past so it should work as well- maybe even better- it also has the advantages of looking in subdirectories I think.

The Dir loop goes something like this:


Dir with no path will give you the next match, and it will return an empty string when there are no more matches.

FWIW, a quick word of warning about filesearch, it has disappeared from Excel 2007, so if this workbook will be used by others stick to DIR.

Stu.

Thanks guys for the help, i really appreciate it!!

Thanks again,
-Cindy