JenniferMurphy
Well-known Member
- Joined
- Jul 23, 2011
- Messages
- 2,687
- Office Version
- 365
- Platform
- Windows
How difficult would it be to write a macro to compare the code in a workbook code module to the code in an add-in?
I sometimes give a workbook to a friend or colleague that depends on VBA code in my personal add-in. I don't want to give out the entire add-in for many reasons, so I usually copy the needed VBA code from the add-in to a workbook code module. Fairly often, the friend will find a bug or request a feature, but now I have two copies of the code. After I have made changes, I would like to compare the two pieces of code to make sure that they are back in sync.
I sometimes give a workbook to a friend or colleague that depends on VBA code in my personal add-in. I don't want to give out the entire add-in for many reasons, so I usually copy the needed VBA code from the add-in to a workbook code module. Fairly often, the friend will find a bug or request a feature, but now I have two copies of the code. After I have made changes, I would like to compare the two pieces of code to make sure that they are back in sync.
