Compare 2 VBA projects

[secoo140]

Hello friends,

I am doing various updates on more than one "workbook". I forget some of the updates I made when it came to order.

Is there an application that compares "workbooks" to prevent this?

vba page is quite limited, i can't even open two codes side by side on the same page. What is your suggestion?

Thank you

 

[rlv01]

I do this all the time. There is nothing I'm aware of that is specific to excel, but there are a number of very good text comparison tools you can use for this. Personally I like Beyond Compare. The general method is to create two folders, one for each workbook. Then export the code modules to their respective folders. Now you can use the text comparison tool.

 

[secoo140]

I do this all the time. There is nothing I'm aware of that is specific to excel, but there are a number of very good text comparison tools you can use for this. Personally I like Beyond Compare. The general method is to create two folders, one for each workbook. Then export the code modules to their respective folders. Now you can use the text comparison tool.

is there any excel extractor? or you are doing everything manually?

 

[rlv01]

Define "excel extractor"

 

[secoo140]

Define "excel extractor"

Let's define it as follows: A tool divides our existing Excel VBA file into a text file. It saves each module and form separately as a text file. In this way, we comfortably control this data with comparison applications.

 

[rlv01]

MZTools, then.