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
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
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
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" <[email protected]> wrote in message
news:[email protected]...
> 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
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" <[email protected]> wrote in message
news:[email protected]...
> 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
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" <[email protected]> wrote in message
news:uxY$IJ9%[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>
Bob,
I couldn't find the VB syntax file.
Got a link ?
NickHK
"Bob Phillips" <[email protected]> wrote in message
news:uXqR4q9%[email protected]...
> 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" <[email protected]> wrote in message
> news:uxY$IJ9%[email protected]...
> > 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" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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
> >
> >
>
>
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" <[email protected]> wrote in message
news:OiNXcu9%[email protected]...
> Bob,
> I couldn't find the VB syntax file.
> Got a link ?
>
> NickHK
>
> "Bob Phillips" <[email protected]> wrote in message
> news:uXqR4q9%[email protected]...
> > 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" <[email protected]> wrote in message
> > news:uxY$IJ9%[email protected]...
> > > 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" <[email protected]> wrote in message
> > > news:[email protected]...
> > > > 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
> > >
> > >
> >
> >
>
>
Bob,
Thanks, but seem to have moved. Now at:
http://www.textpad.com/add-ons/files...sual_basic.zip
etc...
NickHK
"Bob Phillips" <[email protected]> wrote in message
news:OUhaA29%[email protected]...
> 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" <[email protected]> wrote in message
> news:OiNXcu9%[email protected]...
> > Bob,
> > I couldn't find the VB syntax file.
> > Got a link ?
> >
> > NickHK
> >
> > "Bob Phillips" <[email protected]> wrote in message
> > news:uXqR4q9%[email protected]...
> > > 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" <[email protected]> wrote in message
> > > news:uxY$IJ9%[email protected]...
> > > > 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" <[email protected]> wrote in
message
> > > > news:[email protected]...
> > > > > 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
> > > >
> > > >
> > >
> > >
> >
> >
>
>
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" <[email protected]> wrote in message
news:eVwg$H%23%[email protected]...
> Bob,
> Thanks, but seem to have moved. Now at:
> http://www.textpad.com/add-ons/files...sual_basic.zip
>
> etc...
>
> NickHK
>
> "Bob Phillips" <[email protected]> wrote in message
> news:OUhaA29%[email protected]...
> > 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" <[email protected]> wrote in message
> > news:OiNXcu9%[email protected]...
> > > Bob,
> > > I couldn't find the VB syntax file.
> > > Got a link ?
> > >
> > > NickHK
> > >
> > > "Bob Phillips" <[email protected]> wrote in message
> > > news:uXqR4q9%[email protected]...
> > > > 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" <[email protected]> wrote in message
> > > > news:uxY$IJ9%[email protected]...
> > > > > 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" <[email protected]> wrote in
> message
> > > > > news:[email protected]...
> > > > > > 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
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks