VBA for programmers: books? links?

[Vahid Pazirandeh]

Hi all,

Would anyone recommend some books (not references) or URLs to
tutorials worth going through? Maybe some sites that have good VBA
source code that would teach "good practices".

Microsoft.com surely has documentation upon googling, but everything I
found was so broken up - I'm looking for a tutorial that has a flow
and covers different areas of the core language, and how to best write
it.

I've had fun playing with VBA by googling around and getting things
done. But I'd like to make sure I'm learning the nuances of the
language the right way, and that I would code in a good style. I'm
looking for a guide similar in style to the tutorial posted for the
Python language (http://docs.python.org/tut/) which breaks the
concepts down by example, and explains a bit why we would make certain
choices over others.

I've enjoyed reading this site: http://word.mvps.org/FAQs/MacrosVBA/index.htm

Thanks!

-Vahid Pazirandeh

 

[Doug Robbins - Word MVP]

Start with the article "Getting To Grips With VBA Basics In 15 Minutes" at:

http://www.word.mvps.org/FAQs/MacrosVBA/VBABasicsIn15Mins.htm

and browse through other articles on that site.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Ed]

Hi old man (?),

Thanks for the information. Fortunately for me I'm still using 2003

Regards.

Ed

 

[Ed]

Hi Vahid,

For a lot of useful stuff on good coding style, check out the book "Code
Complete" by Steve McConnell. It's not a VBA book but it is an excellent book
on how to produce good code, with examples in several programming languages.

Cheers.

Ed

 

[old man]

For the most complete Word Programming Book (using VBA) try to find Word 2000
Developer's Handbook by Guy Hart-Davis. Its 1271 pages has almost everything
and works on all versions through 2003 and if you have to start doing
extensive Word Programming get the book. It works on later versions too but
with Office 2007 things are really changing.

MS has switched the Word (and all of Office) programming model to Visual
Studio Tools for Office (VSTO) and is very Office 2007 oriented and the
learning curve (for VSTO) is quite brutal. I don't know of any useful book
out yet that Word programmers can use.