6/11/2023 0 Comments Winmerge compare two filesThanks in advance for any help.įor reference of future posters/searchers, here is a method I used for comparing Visual Basic code that exist in separate Excel workbooks. ![]() I realize I've got a lot of questions here. Does anyone know of a utility that allows you to export the entire set of VBA code from a workbook into a single text file? That way I could do one large comparison rather than many smaller comparisons. If I use the text file method, then I (apparently) have to export each module separately. Does anyone recommend a text-file comparison utility that would be suitable? Has anyone used it?īarring this tool, I can export the code to a text file and compare that way. I've seen a piece of old software called VBA Code Compare, but development on this product apparently ended in 2006 with Excel 2003. I know that you can do it by hand, by opening both files and putting the module windows side-by-side in the VBE, but it's tedious.Īre there any VB tools or VBE extensions that will do it automatically? ![]() I got in a position where I have two files containing nearly-identical VBA code, and I need to determine (and aggregate) the differences. Do any Excel pros out there have a preferred method of comparing the code in two VBA modules to determine the differences (e.g., code from two separate Excel files, such as two versions of the same workbook)?
0 Comments
Leave a Reply. |