vba code structures

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » VBA code structures - question for Anthony | Access forum

VBA code structures - question for Anthony | Access forum

resolvedResolved · Medium Priority · Version 2007

Michael has attended:
Excel Intermediate course
Excel Advanced course
Excel VBA Intro Intermediate course

VBA code structures - question for Anthony

Anthony
During last weeks training you mentioned that there are tools available to convert existing code (or parts of code) into a decision tree. Can you point me towards some of these?
Many thanks
Michael

RE: VBA code structures - question for Anthony

Hi Michael, thanks for your query. Have a look at this:

http://www.dailydoseofexcel.com/archives/2007/12/13/vba-code-documenting-tools-project-analyser-and-visustin/

Obviously, I wouldn't recommend spending vast amounts of money for a licence, but this is an example of what can be done, if nothing else when you are teasing out the logic of you code. Also Google the key words in the article, there are freeware versions of similar software out there.

Hope this helps,

Anthony

Wed 23 Jun 2010: Automatically marked as resolved.

 

Training courses

 

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Access tip:

Action queries

Unlike select queries you cannot use action queries as a data source for the use with forms or reports,as they do not return a dataset that can be read.

View all Access hints and tips


Server loaded in 0.08 secs.