Utility: Which fields have been accessed by a program ??

Is there a utility that can tell me which data items in my programs have been used after I run the programs?


Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

None that I know of, but, what I've done in the past is use the On_Change event of the controls I wish to monitor and then write their names to an array.  I currently have a program in the works that monitors text boxes for a change and if one is changed, enables a save button.

It's a bit ugly, but it works.

cmmcginnAuthor Commented:
I see.  I was actually thinking about monitoring the use of variables, constants, etc. that are in my programs.


You could use a project analyzer like e.g.

Some you can try out for 30 days, just see which one you like.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
cmmcginnAuthor Commented:
Thanks.  I'll take a look.

Looks to me like Project Analyzer finds dead code, that is, subs that are not called from anywhere in the program, variables that are declared but not assigned, but it does this by static analysis of the code.  Doesn't matter how many times or ways one runs the program, dead code will never execute

My reading of the questions is that he's looking for coverage analysis, that is, during a given run of a program which subs were called, which variables assigned and which were not.  If Project Analyzer does that, great, if not, I'd like to know what tool does.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.