Macro- Copying Multiple Workbooks into Master

[eric.cappelli]

Hi Everyone

I have created a macro that opens up to 15 files and then adds a new column at the end of each one. It is then supposed to copy this into a master workbook. Unfortunately, I have only been able to write the code so that it copies the data over for one of these workbooks. This is in Excel 2003. Below is the code I am working with:

'Loading .xls files in to the form

Please Login or Register  to view this content.

If anyone can provide some assistance with this so that the macro will copy over multiple workbooks to the master which is currently titled macro.xls that would be greatly appreciated.

Thanks

Eric

[arthurbr]

Your post does not comply with Rule 5 of our Forum RULES. We have Seven question forums: Miscellaneous, General, Programming, Worksheet Functions, Charting, Excel 2007 Help and New Users. Please choose the appropriate forum, and post your question in ONLY one forum.