Thread: VB Code
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default VB Code

Ray,

I've never had a need to compare code modules, but the following wouldn't take long to try out...

Copy the text from both modules into separate columns on a worksheet.
They should both start in the same row.
In an adjoining column use the "Exact" function to determine whether each line is identical;
something like "=EXACT(B5,F5)" and fill down.

This won't identify what was changed, but it will tell you what lines to check.

Regards,
Jim Cone
San Francisco, CA

"Ray Batig" wrote in message ink.net...
Greetings,
I have two versions of the same workbook with different versions of VB code.
Is there some software out there that will compare the VB code and show the
differences. The only thing I can think of is printing out both workbook's
codes and then manually comparing them line by line. Any advice will be
appreciated.
Thanks in advance.
Ray