VBA Class

[Angie M.]

Hello,

I'm teaching a 2 day Intro to VBA for MS Word class and was wondering if
anyone had a recommendation for a training guide, reference guide, quick ref
guides etc. that I can purchase and use for my students. I've already
checked Amazon and there are a few things, but wanted to check with you all.
Thanks

 

[Greg Maxey]

IMHO that is like asking for Cliff Notes on War a and Peace. You might
touch the surface, but never see the grand scope. I have been scratching at
VBA for almost two years (in class every day ;-) ) and I still feel like the
village idiot.

 

[Jezebel]

This is actually two questions, according to quite what your course is
trying to achieve: VBA as a programming language and platform vs. Word as an
object model to be manipulated by VBA.

Generically, Word VBA is the same as all the other VBAs (by definition). As
a language it is essentially the same as VB; and there are plenty of
reasonable VB texts around. If you are comfortable with the concepts and
syntax of VB, then it is relatively easy to apply that knowledge to any
specific object model such as Word, Excel, Access, or anything else that
uses VBA.

Working the other way round -- starting with a specific object model and
trying, from there, to infer the principles and syntax for manipulating that
object -- is a great deal harder (as Greg's answer testifies).