|
Comparison of modules
Is there any way to automatically compare line-by-line the contents of two
modules from two different workbooks, in a way similar to the document comparison functions within word processors? -- Lon Sarnoff |
Comparison of modules
I feel silly responding to my own post. But I just realized that I can
export the modules and then compare them within the word processor. Is there any way of doing it without exiting Excel? -- Lon Sarnoff "Lon Sarnoff" wrote: Is there any way to automatically compare line-by-line the contents of two modules from two different workbooks, in a way similar to the document comparison functions within word processors? -- Lon Sarnoff |
Comparison of modules
You could export the modules from VBA, and then read them back in as text
files, comparing as you go. The problem with that is knowing when a fatal mis-match occurs, you would have to code all of that. Other programs tend to already have that sort of comparison facility built-in (I use Textpad). -- HTH RP (remove nothere from the email address if mailing direct) "Lon Sarnoff" wrote in message ... I feel silly responding to my own post. But I just realized that I can export the modules and then compare them within the word processor. Is there any way of doing it without exiting Excel? -- Lon Sarnoff "Lon Sarnoff" wrote: Is there any way to automatically compare line-by-line the contents of two modules from two different workbooks, in a way similar to the document comparison functions within word processors? -- Lon Sarnoff |
Comparison of modules
Lon,
Whilst it does not compare the text directly, this add-on is useful: http://www.mztools.com/ Also, TextPad has an ASP syntax file that you could extend to cover you needs in VB/VBA: http://www.textpad.com/ NickHK "Lon Sarnoff" wrote in message ... Is there any way to automatically compare line-by-line the contents of two modules from two different workbooks, in a way similar to the document comparison functions within word processors? -- Lon Sarnoff |
Comparison of modules
You can also get a VB syntax file, and it would be no great difficulty to
extend that for VBA/Excel. -- HTH RP (remove nothere from the email address if mailing direct) "NickHK" wrote in message ... Lon, Whilst it does not compare the text directly, this add-on is useful: http://www.mztools.com/ Also, TextPad has an ASP syntax file that you could extend to cover you needs in VB/VBA: http://www.textpad.com/ NickHK "Lon Sarnoff" wrote in message ... Is there any way to automatically compare line-by-line the contents of two modules from two different workbooks, in a way similar to the document comparison functions within word processors? -- Lon Sarnoff |
Comparison of modules
Bob,
I couldn't find the VB syntax file. Got a link ? NickHK "Bob Phillips" wrote in message ... You can also get a VB syntax file, and it would be no great difficulty to extend that for VBA/Excel. -- HTH RP (remove nothere from the email address if mailing direct) "NickHK" wrote in message ... Lon, Whilst it does not compare the text directly, this add-on is useful: http://www.mztools.com/ Also, TextPad has an ASP syntax file that you could extend to cover you needs in VB/VBA: http://www.textpad.com/ NickHK "Lon Sarnoff" wrote in message ... Is there any way to automatically compare line-by-line the contents of two modules from two different workbooks, in a way similar to the document comparison functions within word processors? -- Lon Sarnoff |
Comparison of modules
Hi Nick,
I have 4, http://www.textpad.com/add-ons/files/vb.zip http://www.textpad.com/add-ons/files/vb5.zip http://www.textpad.com/add-ons/files/svb.zip http://www.textpad.com/add-ons/files/visual_basic.zip The last is VB6 specific. They even have VB.Net and VBScript syntax files. -- HTH RP (remove nothere from the email address if mailing direct) "NickHK" wrote in message ... Bob, I couldn't find the VB syntax file. Got a link ? NickHK "Bob Phillips" wrote in message ... You can also get a VB syntax file, and it would be no great difficulty to extend that for VBA/Excel. -- HTH RP (remove nothere from the email address if mailing direct) "NickHK" wrote in message ... Lon, Whilst it does not compare the text directly, this add-on is useful: http://www.mztools.com/ Also, TextPad has an ASP syntax file that you could extend to cover you needs in VB/VBA: http://www.textpad.com/ NickHK "Lon Sarnoff" wrote in message ... Is there any way to automatically compare line-by-line the contents of two modules from two different workbooks, in a way similar to the document comparison functions within word processors? -- Lon Sarnoff |
Comparison of modules
Bob,
Thanks, but seem to have moved. Now at: http://www.textpad.com/add-ons/files...sual_basic.zip etc... NickHK "Bob Phillips" wrote in message ... Hi Nick, I have 4, http://www.textpad.com/add-ons/files/vb.zip http://www.textpad.com/add-ons/files/vb5.zip http://www.textpad.com/add-ons/files/svb.zip http://www.textpad.com/add-ons/files/visual_basic.zip The last is VB6 specific. They even have VB.Net and VBScript syntax files. -- HTH RP (remove nothere from the email address if mailing direct) "NickHK" wrote in message ... Bob, I couldn't find the VB syntax file. Got a link ? NickHK "Bob Phillips" wrote in message ... You can also get a VB syntax file, and it would be no great difficulty to extend that for VBA/Excel. -- HTH RP (remove nothere from the email address if mailing direct) "NickHK" wrote in message ... Lon, Whilst it does not compare the text directly, this add-on is useful: http://www.mztools.com/ Also, TextPad has an ASP syntax file that you could extend to cover you needs in VB/VBA: http://www.textpad.com/ NickHK "Lon Sarnoff" wrote in message ... Is there any way to automatically compare line-by-line the contents of two modules from two different workbooks, in a way similar to the document comparison functions within word processors? -- Lon Sarnoff |
Comparison of modules
Sorry, that was my typo, I had to type them as downloads have no URL to
copy. -- HTH RP (remove nothere from the email address if mailing direct) "NickHK" wrote in message ... Bob, Thanks, but seem to have moved. Now at: http://www.textpad.com/add-ons/files...sual_basic.zip etc... NickHK "Bob Phillips" wrote in message ... Hi Nick, I have 4, http://www.textpad.com/add-ons/files/vb.zip http://www.textpad.com/add-ons/files/vb5.zip http://www.textpad.com/add-ons/files/svb.zip http://www.textpad.com/add-ons/files/visual_basic.zip The last is VB6 specific. They even have VB.Net and VBScript syntax files. -- HTH RP (remove nothere from the email address if mailing direct) "NickHK" wrote in message ... Bob, I couldn't find the VB syntax file. Got a link ? NickHK "Bob Phillips" wrote in message ... You can also get a VB syntax file, and it would be no great difficulty to extend that for VBA/Excel. -- HTH RP (remove nothere from the email address if mailing direct) "NickHK" wrote in message ... Lon, Whilst it does not compare the text directly, this add-on is useful: http://www.mztools.com/ Also, TextPad has an ASP syntax file that you could extend to cover you needs in VB/VBA: http://www.textpad.com/ NickHK "Lon Sarnoff" wrote in message ... Is there any way to automatically compare line-by-line the contents of two modules from two different workbooks, in a way similar to the document comparison functions within word processors? -- Lon Sarnoff |
| All times are GMT +1. The time now is 01:03 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com