Results 1 to 10 of 10
  1. #1
    5 Star Lounger
    Join Date
    Jul 2001
    Location
    Terneuzen, Netherlands
    Posts
    895
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Compare VBA code tool (EXCEL 97/2000)

    Anyone who can point me to a tool that allows me to compare two EXCEL sheets wrt the VBA code used in their resp. modules?

    Thanks,

    Erik Jan

  2. #2
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Compare VBA code tool (EXCEL 97/2000)

    I've used SourceSafe for staright VBA code, and it's excellent for that. I know it's available for Office, but I don't know if you can compare the code straight off like you can with VB.

    Do you just need to know if they're the same, or do you want to know where they differ?

    One way, you could write VBA code easily- the other way would involve heaps more.
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  3. #3
    5 Star Lounger
    Join Date
    Jul 2001
    Location
    Terneuzen, Netherlands
    Posts
    895
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Compare VBA code tool (EXCEL 97/2000)

    <font face="Comic Sans MS">I'd like to know where & how they differ...

    I know (and am a reg. user) of a great tool called VBACodePrint (<A target="_blank" HREF=http://www.starprint2000.com>http://www.starprint2000.com</A>); this is printing it... What I need next is something to compare the (text) files...

    I had hoped someone would have or know of such a tool...

    Erik Jan</font face=comic>

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Compare VBA code tool (EXCEL 97/2000)

    Hi,
    I don't know offhand of a tool that does that, but you could print the code to two text files and then use the DOS fc command to compare those files.
    Hope that helps.
    Regards,
    Rory

    Microsoft MVP - Excel

  5. #5
    Star Lounger
    Join Date
    Feb 2001
    Location
    Virginia Beach, Virginia, USA
    Posts
    80
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Compare VBA code tool (EXCEL 97/2000)

    MS has a tool called WinDiff which will compare 2 files or 2 dirs. If you want to compare your code, export it to a .bas and then use WinDiff on the 2 files. The app graphiclly shows what is the same and different in the files.

  6. #6
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Compare VBA code tool (EXCEL 97/2000)

    Erik

    What kind of sheet comparison do you want to perform?

    I guess you can compare cells if they have the same values, if they have the same format, if they have the same height and width, one worksheet can have VBA code attached to it, I mean you an compare a whole lot of things. can you be specific?

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  7. #7
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Compare VBA code tool (EXCEL 97/2000)

    Drop the code to *.bas files, open one of them in Word, and use Word's "Tools, Track Changes, Compare Documents" capability to compare the open version to the "unopened" one. (It's been a while since I've done this, so my instructions are general, but should work with perhaps some tweaking.)
    -John ... I float in liquid gardens
    UTC -7ąDS

  8. #8
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Compare VBA code tool (EXCEL 97/2000)

    Erik

    <<< What I need next is something to compare the (text) files... >>>

    Check TextPad at http:// www.textpad.com and see if this can do the trick for comparing VBA code in two text files.

    I used it and it works.

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  9. #9
    5 Star Lounger
    Join Date
    Jul 2001
    Location
    Terneuzen, Netherlands
    Posts
    895
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Compare VBA code tool (EXCEL 97/2000)

    All,

    Thanks for the feedback. I'll certainly try to do all of that. Problem is that I'm lazy and had hoped there would have been some program that would do this all automatically...

    Erik Jan

    PS1. To add some clarification: I'm looking to compare VBA-code only. Look at www.synkronizer.com for a tool that compares EXCEL sheets (I know there's more programs like this).

    PS2. To compare files & directories, try: FolderMatch (www.foldermatch.com)

  10. #10
    New Lounger
    Join Date
    Nov 2001
    Location
    London
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Compare VBA code tool (EXCEL 97/2000)

    Hi,

    I believe UltraEdit 32 will also do what you want (plus a lot more). You can find it at <A target="_blank" HREF=http://www.ultraedit.com/>http://www.ultraedit.com/</A>
    Edited to add hyperlink

    Alex

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •