VBA Code Version Differences

[leydorfs]

Thanks for taking my question.

Is there any way to compare two excel files and have their vba code compared, and differences hi-lited. This would be used for comparing different versions of the same excel/vba file. I'd like to do it within excel if possible (with opposed to exporting the vba and then comparing it).

thanks.

 

[Norie]

How closely do you want to compare the code?

When I wanted to do that I just copy the code into 2 adjacent columns and put a formula in a 3rd.

This only works with code that is very similar though.