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 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.

 

[isaia]

Hello!

Don't know if this will be useful to you but there's a short Microsoft
webcast you can view entitled, "Tips & Tricks for Using Simple Word VBA Every
Day: It's Much Easier than You Think! (Level 300)." It's sort of an overview
of VBA. The link is
http://office.microsoft.com/en-us/webcasts/HA102582061033.aspx.

Good luck!

 

[Noob McKnownowt]

Hi Garrisonwa1,

i can only really suggest something for the VBA side, so hear goes;

create test cases for these guys. for example create a small app that you
can introduce problems into and then give them these problems to solve, such
as an infinate loop problem for example, something that will require them to
step through the code and understand what each line does as it is executed.

as for reading the code i would try and burn into their memory the imprtance
of variable naming conventions and the improtance of consistancy when
programming.

apart from this website there is a good VBA forum called ozgrid that i use,
the ozgrid site has many tutorials for all levels.

hope this helps,

Noob.