RE: VBA Training



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.

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

.



Relevant Pages

  • Re: VB .net - A question for Microsoft Moderators...
    ... concrete information on the direction of VBA and of any VSA successor is ... I've never been happy with placations from Microsoft that ... Visual Studio white papers and scan through Visual Studio Express Beta's only ... > is still there as the only integrated method for doing Office programming. ...
    (microsoft.public.office.developer.vba)
  • Re: Is Excel VBA best for me?
    ... > retired and searching for a programming environment ... > expect to integrate the simulations into Excel spreadsheets. ... > Excel VBA seems like an "obvious choice", ...
    (microsoft.public.excel.programming)
  • Re: Word 2003 VB IDE & VB2005
    ... VB.NET syntax can't easily be grafted into the internal layout of templates to replace VBA for reasons of backwards compatibility, and the VB.NET IDE can't be made available with VBA as the language being edited, unless the underlying code for the editor were fundamentally changed. ... Another is performance of the completed application, another is the time and effort necessary to create a deployment package. ... The principles involved in programming are much the same, and sound programming techniques can be taught and learned in any language. ...
    (microsoft.public.word.vba.general)
  • Re: Why VBA is a good programing language
    ... VBA is a fine programming ... > supporting a VBA application on a large scale are a serious. ... templates using SMS or login scripts. ... thoroughly badly behaved applications like the Acrobat add-in. ...
    (microsoft.public.word.vba.customization)
  • Re: Excel: ADDRESS cannot be used in CELL. How stupid is this?
    ... to keep Excel from crashing when I use the evalaute formula ... use VBA to manipulate data with Word/Access ... How lame is the 'talent' programming Excel? ...
    (microsoft.public.excel.worksheet.functions)