Excel 2007 : opening multiple excel files, getting partial data from it and then paste in to other

[hunza]

I have 144 excel files in one folder, their name ranged from 001, 002, 003, .....156 (File names correspond to subject ID, some of the subjects are missing)

I want to get partial data from each file and then paste into a new file to generate a table with three col. like below

FileName (Name of file) SubjectName (Subject name preset in sheet:subject info) TST (Sum of N col of every excel File:sheet:data)


I have already develop a macro which can open & read certain info from single individual excel file and then paste in the single excel file. I need to put in the loop, so it can work with all 144 files as once.

Please Login or Register  to view this content.

Thanks
Munir

[davesexcel]

All sorts of help on this topic here is one,
http://www.excelforum.com/excel-gene...worksheet.html