Mark...
thanks for trying to help me with this....
There is one common partname for these files. I have one folder titled
"trbtix06" where I keep two sheets (TrbTk1G & Trbtk1D). The files i
need are saved as "TrbTk1G..." then they will have something like
".01066.xls in which "01" is the month, "06" is the date, and "6" is
the date of the week. all the files are in one folder. I do need to do
a select all, there are not headers on the sheet.There is only one
sheet in each workbook....I will email you an example of our the sheets
I use.