Trying to import data from a range of closed excel files

Hi

I have been trying to get this code to import data from a range of closed excel files in a folder and can't get it to work. I have modified codes form the web to pull in the data from one file - see below. But can't get it to loop through to grab it from a range of files. The data is in the same place in each file. There are approximately 50 files. The data is in a table that is 4 columns wide and 5 rows down, I need all the data to display in row 1 for the first set of data, then row 2 for the second and so on.

Can you help???

Please Login or Register  to view this content.