-
Solved: Two versions of one project -- oops!
I've been working on a large project for quite some time, careful to save with a new file name after each major bit of work. MyProject001.xls, MyProject002.xls, etc.
Well, I goofed. Don't ask me how, it's too foolish to go into. But from MyProject035.xls, there are now two successor files, each of which has some (different) new additions, call them MyProject036CoolCode.xls, and MyProject036NewStuff.xls. Yeah, really, really clever, I know.
Is there a way to compare the two 036 versions and find out where code that isn't the same in them resides? Most of the changes are in big blocks in separate places, and it won't be hard to put them back together into a 037 version that has the new stuff from both of the 036's, but I'd really like to make sure I don't miss tiny little changes that I made somewhere else.
Anybody know of a tool or method to see where the code in the two spreadsheet files differs? (The data in the worksheets is significantly different, but that's not a concern, just where the differences are in the code.)
Many thanks,
G.T.
-
-
The VBE also has the capability of tiling code windows, so I would:
- open the two files
- close all their code windows
- open two same modules
- close project explorer and props window
- window, tile vertically
-
You could also export the code modules, this dumps them into text files, and use one of the many free text editors out there that does file comparisons.
-
Good inputs, many thanks!
Solved.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules