VBA Training

[garrisonwa1]

Hello --

I have been tasked with training a number of analysts who will be supporting
an in-house customized VBA application. The application uses Java, VBA and
XML. The majority of the coding is complete once it reaches the client teams
for ongoing support. However, these analysts will need to troubleshoot the
code as well as potentially implement new functionality. That being said, the
background of these analysts is not in programming. Many of them are somewhat
SQL savvy, as well as COBOL savvy, but are not familiar VBA or any flavor
thereabouts.

Beyond the basic VBA how to's and basic programming skills (loops, case
stmts, etc), I am having a hard time locating (or developing) material for
the "next level" of knowledge. This level would be more along the lines of
reading and debugging VBA code. The class after this level is already in
development and is geared towards VBA specifically in this customized
application.

I am having a hard time plugging this knowledge gap and would appreciate any
tips or suggestions.

Thanks in advance for any assistance you can offer.

 

[Jay Freedman]

Hello --

I have been tasked with training a number of analysts who will be supporting
an in-house customized VBA application. The application uses Java, VBA and
XML. The majority of the coding is complete once it reaches the client teams
for ongoing support. However, these analysts will need to troubleshoot the
code as well as potentially implement new functionality. That being said, the
background of these analysts is not in programming. Many of them are somewhat
SQL savvy, as well as COBOL savvy, but are not familiar VBA or any flavor
thereabouts.

Beyond the basic VBA how to's and basic programming skills (loops, case
stmts, etc), I am having a hard time locating (or developing) material for
the "next level" of knowledge. This level would be more along the lines of
reading and debugging VBA code. The class after this level is already in
development and is geared towards VBA specifically in this customized
application.

I am having a hard time plugging this knowledge gap and would appreciate any
tips or suggestions.

Thanks in advance for any assistance you can offer.

I'll recommend Chapter 21 of "Advanced Microsoft Office Documents 2007 Edition
Inside Out" by Stephanie Krieger (ISBN 978-0-7356-2285-2). You may also find
some of the articles in the Macros section of the Word MVPs web site (listed in
my signature) to be useful.