Book of Office XP VBA programming

[Raphael Goubet]

Hi,

I'm looking for an introduction book on VBA programming for Office XP
in general. There are plenty on programs in particular such as Excel,
Word, Access, but I'm having difficulties finding one covering the
basics of the whole suite.

There seems to be one by MS Press on Office 2000 ("Visual Basic for
Applications Fundamentals" by David Boctor).

Is there an equivalent for Office XP?

Thanks in advance.

Raphael

 

[Howard Kaikow]

VBA is essentially a common core for each of the Office apps. Each app then
adds VBA for an app dependent object model.
If you learn the core with one app, then you can easily apply your knowledge
to another app.

If you are concerned about automating one app from another, the mechanism is
the same for all apps, but the details of the app specific object model
differ greatly.

I suggest picking the app you use most and concentrate there for a bit.

For a list of Word VBA books and my associated rants see the Word VBA book
list at my URL below.

 

[Raphael Goubet]

VBA is essentially a common core for each of the Office apps. Each app then
adds VBA for an app dependent object model.
If you learn the core with one app, then you can easily apply your knowledge
to another app.

That's exactly why I hoped I could find a book covering the basics of
VBA for all Office applications. I'd need VBA for both Word and Excel,
and probably other applications as well, so it would be easier for me
to learn it all from one single source. Boctor's book seems to be
exactly what I'm looking for, but it's out of date.

Raphael

 

[Howard Kaikow]

The common parts of VBA are (almost) the same in all the Office apps.

Start with the app with which you feel most comfortable.

The Excel VBA books are the best of the lot, so I'd suggest starting with
Excel.