| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Public, Private, Event modules, Forms modules,,, | Excel Programming | |||
| Basic question - modules and class modules - what's the difference? | Excel Programming | |||
| VBA modules | Excel Programming | |||
| When to code in sheet or userform modules and when to use modules | Excel Programming | |||
| Class Modules vs Modules | Excel Programming | |||
Linear Mode
