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
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
Bookmarks