Hello all,
I am facing a very serious problem. I need help in form of an excel macro. I will explain my torubles in short.
I want to extract data from some 12000 work books and pasted in a newworkbook. all this while without opening those 12000 files.
Info:
Files :"P046000.xls" to "P057999.xls".
Cells to extract information from: "C2, I57, I58".
Info to be copied to A2, B2, C2 and so on for 12000 rows, keeping the 3 columns common.
Need help. Please if somebody could help?
Jack
I am facing a very serious problem. I need help in form of an excel macro. I will explain my torubles in short.
I want to extract data from some 12000 work books and pasted in a newworkbook. all this while without opening those 12000 files.
Info:
Files :"P046000.xls" to "P057999.xls".
Cells to extract information from: "C2, I57, I58".
Info to be copied to A2, B2, C2 and so on for 12000 rows, keeping the 3 columns common.
Need help. Please if somebody could help?
Jack