VBA reference book recommendation

Topic

New Reply

Can anyone recommend a good general VBA reference book? Something that would cover VBA used in all the Office applications including example code.

Thanks

Reply | Quote

Replies

Richard,

You may find it hard to find one book that does it all since VBA is actually made up of 2 parts the VBA control language which is common to all the applications and the Object Model which is specific to the application being used. Because of this most books on the subject are application specific.

Here are some of my favorites:
VBA for Dummies, Steve Cummings ISBN:0-7645-0856-3 – A good general intro that’s easy to understand.
VB & VBA in a Nutshell, Paul Lomax ISBN:1-56592-358-8 – Good Reference Language Reference
Writing Word Macros, Steven Roman ISBN:1-56592-725-7
Writing Excel Macros, Steven Roman ISBN: 1-56592-587-4
Microsoft Access VBA Programming, Second Ed, Michael Vine ISBN: 1-59200-723-6
Special Ed. Using Excel Visual Basic for Applications 2nd Ed, Jeff Webb ISBN: 0-7897-0269-X – More in depth
Professional Excel Development, Bullen, Bovey, & Green ISBN:0-321-26250-6 – Heavy Duty

Good Luck.

RG

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Reply | Quote

Many thanks.
This will help a lot.

Reply | Quote

For pure VBA, it’s hard to beat the “VBA Developers Handbook” by Getz and Gilbert. It is worth its (considerable) weight in gold.

Reply | Quote

Got to agree with Rory’s post. Since VBA hasn’t really been revised for a number of years, this book is phenomenal.

Reply | Quote