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.
Please Login or Register  to view this content.
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