I am running the code line-by-line. It is going through the code fine and copying data from each book and pasting it into the MasterCombine workbook. However, when it gets the last workbook, everything is deleted and it reverts back to the original file with original data. It appears to be crapping out when it gets to command that opens file.
I can't for the life of me figure out what is wrong. Any help is appreciated. I am trying the code in Excel 2003.
I have all the data in one path, which is "G:\Excel Tips\Combine Workbooks\WorkbookData\" The files are:
Book1
Book2
Book3
Book4
Book5
MasterCombine (contains code to combine Book 1-5)
I have another path, which is "G:\Excel Tips\Combine Workbooks\WorkbookData\Import\"
This folder is empty.
Bookmarks