Pull values from many Excel files
Posted by RT on August 17, 2001 11:49 AM
How can one value be pulled from a predefined cell from each of many spreadsheets? I have a folder that contains as many as 50 Excel files which represent the current week's invoices. The file names are different each week. I want to make a table of the total invoice amount from each file. My main difficulty is in using a macro to open each file in sequence without having a list of the file names prepared in the spreadsheet running the macro.