Macro to Combine Multiple Workbook Data into Single Target Workbook

Hi,

I have the following code that I used for a prior project using Excel 2003 and its related libraries. The code was used to pull data from a folder full of excel files that all had the same single page layout but different data and combine the data in a single target-workbook.

I am now trying to use the same code with Excel 2010 to go through a folder of new excel files that have a different layout than in the prior project. With the new files (see attached example) I want to copy the source data from the "Enter Data Here" sheet and add it to the destination workbook that is running the macro. (Please note that the "Enter Data Here" is not always consistently the same sheet number from one file to the next, so we would need to reference the sheet name and not the number.)

- I was planning to have the destination workbook receive the combined data on the sheet called "Pasteit".

When I run the code in Excel 2010, it opens the first file and then hangs on line 28. I feel like I'm missing something obvious.... your advice would be greatly appreciated!

Please Login or Register  to view this content.