Hi all, I would like to create an excel file to extract data from several files daily.
The files to be extract from are named as: 06032009_1.xls, 06032009_2.xls ,....
However the files I receive at my end are named as the following format: date_#.xls

Is that possible to enter a files in the excel file for example : 06032009. It will go and locate all the files starting with 06032009_#,located in the folder and copy all the data into the current worksheet.

I would like to find a solution to this, as I need to open more than 20 files everyday to copy and paste into the summarised worksheet everyday. Anyone can help me ?