Excel pulling data from files

[psnewjen]

I have an Excel workbook that acts like a log of Excel reports that are generated and stored in a specified folder. I would like this workbook, upon opening, to pull data from various cells from all of the files in the folder, preferably without opening the source files. I don't want to tell the code what files to pull from. I would like it to pull from all in the folder, as there are new files generated often. I am new to VBA and trying to bite off more than I can chew. Does anybody know the code for doing this? Thanks

 

[John_w]

Use a Dir function loop to loop through Excel files in the folder. Call Workbooks.Open inside the loop to open each file and import/copy data. Or if you don't want to open the source files use a database query (ODBC or OLEDB connection) in the loop (more complicated and less flexible). Either way, record a macro to get the starting code.