I have two workbooks, call them wb1 and wb2. wb2 was initially a copy of wb1, and it was created so I could fix code problems in the macros. Since I had to do a lot of data testing, the worksheets in wb2 are now bad, i.e. the data is incorrect, missing, or victim to bugs. The code in wb2 is now fixed. So what I want is a new workbook, wb3 with wb1's data and wb2's code. Is there any easy way to do this?
I tried "import/export" from ASAP and that tool does not do what I want. I know I can copy all my code to Notepad and then copy from Notepad files back to the good data workbook, but there are lots of places (seven) to copy and many potential errors. Surely someone else has faced this problem.
Ideas?