I'm by far no programmer, but I have a nasty problem that
I think can only be over-come with some serious
programming.

I need to pull data from a HUGE number of Excel files -
2800 and counting.

Here are my problems:
- The files are in a defined directory structure that
will change and expand over time.
- The number of files will continue to expand over time.
- The length of the files will fluctuate over time.
- There are blank rows intermitently through out the data
I need to retrieve.
- The data I need does not start at cell A1.
- The data I need might not consistently start on the
same row.
- I need to introduce either the name of the file or the
name of the sub-directory into the data set.
- I will ultimately be sending all of this to Access.

I had access to a programmer that was able to dump the
directory structure to an array and then read some
specific cell values into a table in Access, but I've
lost contact with him.

Can anyone help?