Compare VBA code tool (EXCEL 97/2000)

Topic

New Reply

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

Reply | Quote

Replies

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.

Reply | Quote

I’d like to know where & how they differ…

I know (and am a reg. user) of a great tool called VBACodePrint (http://www.starprint2000.com); 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

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

Hi,

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

Alex

Reply | Quote

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.)

Reply | Quote

Erik

<<>>

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

I used it and it works.

Wassim

Reply | Quote

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 http://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 (http://www.foldermatch.com)

Reply | Quote

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

Reply | Quote