aesmike
asked on
Access VBA Source Code Comparison
I'm looking for a set of tools to help me manage my vba code. I have developed one product but has slightly different versions, depending on where its installed. It's installed in 10 different customers so that's 10 different versions of the code.
I want to perform a gap analysis to analyze the differences between installations. One of the most critical things I need to do is to produce a list of differences down to the function/procedure level.
In other words, Customer A and Customer B have very similar versions to each other. 98% of the code is the same. However, 2% of the subs or fucntions are different. "Show me a list..."
Is there a commercial version of this available so I don't have to roll my own?
Thanks.
-Mike
I want to perform a gap analysis to analyze the differences between installations. One of the most critical things I need to do is to produce a list of differences down to the function/procedure level.
In other words, Customer A and Customer B have very similar versions to each other. 98% of the code is the same. However, 2% of the subs or fucntions are different. "Show me a list..."
Is there a commercial version of this available so I don't have to roll my own?
Thanks.
-Mike
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Scott McDaniel (EE MVE )
I own and use Total Access Detective. It is VERY thorough, and is possibly the best out there for what you're looking at. It can get very granular, but then that's what you're looking for with something like this.
If you're looking for a free solution. I would suggest a program i use at work to compare large text files. It is called Beyond Compare.
Essentially, you tell it the 2 files that you want to compare and it does a character by character comparison and shows your differences in red. it will read the text out of any file that has 'raw' text in it, regardless of the extension. So you can just export your modules, and compare.
Hope this helps
AR
Essentially, you tell it the 2 files that you want to compare and it does a character by character comparison and shows your differences in red. it will read the text out of any file that has 'raw' text in it, regardless of the extension. So you can just export your modules, and compare.
Hope this helps
AR
I don't think Beyond Compare is free, since I have a licensed version.
mx
mx
@DatabaseMX:
You're right. I thought of that just after i clicked submit. Silly me. I guess it just seemed free to me because I dind't pay for it. How much was your license, out of curiosity?
AR
You're right. I thought of that just after i clicked submit. Silly me. I guess it just seemed free to me because I dind't pay for it. How much was your license, out of curiosity?
AR
It's an excellent program for sure, but probably not quite what Mike needs in this case.
Check their website for the cost.
mx
Check their website for the cost.
mx
Will functions/procedures be named the same?
ASKER
Thanks, Joe.
Sorry for the delay. Haven't used EE in a while and I guess the email alerts were turned off.
FYI, EE took away my unlimited questions status. what is the world coming to when I have to use earned points! I guess at EE it's "What have you done for me lately"
Sorry for the delay. Haven't used EE in a while and I guess the email alerts were turned off.
FYI, EE took away my unlimited questions status. what is the world coming to when I have to use earned points! I guess at EE it's "What have you done for me lately"