VBA Code Dependency

Posted on 2009-04-16
Last Modified: 2012-05-06
I inherit a lot of Access VBA projects from others.  It can take a lot of time to figure out how subroutines and functions relate to each other.

Is there any freeware on reasonably price software that will analyze vba code and create an outline something like Access' object dependency?

I'll award points to the person who gives me one that works and is the least expensive compared to others that work.
Question by:vlvawter
    LVL 75

    Expert Comment

    by:DatabaseMX (Joe Anderson - Access MVP)
    It doesn't get any better or cheaper than this:

    I've been using F&R for 15 years 24x7x365

    get it.


    Author Comment

    I appreciate your suggestion, but this isn't what I want.  I did something that will give me a dependency layout.  From what I can tell, this won't do that.
    LVL 75

    Accepted Solution

    Actually, you can run a cross reference report.  However, it does not drill down endlessly on dependencies.  This question has come up before, but no one has found a free or 'cheap' tool to do this.

    You might find it here, but the tools are a bit more pricey, but otherwise excellent:


    Author Closing Comment

    Well, I waited a few more days for a possible answer; so, I'll give the points to you.  If freeware or inexpensive shareware isn't there, then it isn't there.  Thanks.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
    A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
    Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
    With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now