VBA Training   

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.

date: Tue, 29 Jul 2008 13:47:01 -0700   author:   garrisonwa1

Re: VBA Training   

On Tue, 29 Jul 2008 13:47:01 -0700, garrisonwa1
 wrote:

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

--
Regards,
Jay Freedman
Microsoft Word MVP        FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit.

date: Tue, 29 Jul 2008 17:22:53 -0400   author:   Jay Freedman

Re: VBA Training   

Will do -- thanks for the references

"Jay Freedman" wrote:

> 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.
> 
> --
> Regards,
> Jay Freedman
> Microsoft Word MVP        FAQ: http://word.mvps.org
> Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit.
>

date: Wed, 30 Jul 2008 12:16:46 -0700   author:   garrisonwa1