Results 1 to 7 of 7
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Fishburn, Durham, England
    Posts
    125
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Book recommendations - VBA for word (2000/SR-1)

    I'm hooked on trying to learn VBA to help me with Word. Can anyone recommend a particularly valuable book? I couldn't find any dedicated to Word (though there are for Excel and Access).

    All suggestions appreciated. I would say I have a fairly good grasp of Word itself, but have not programmed in VBA before I attempted to automate a template - see one of my other postings. I do tend to pick things up quickly (I think) and I have had past experience programming in Pascal and C (though a very long time ago). <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

  2. #2
    Star Lounger
    Join Date
    Aug 2001
    Location
    Hampshire, England
    Posts
    57
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Book recommendations - VBA for word (2000/SR-1)

    "Writing Word Macros" (more complex than the title would suggest, but not intimidating) by Steven Roman has been good to me. It's an O'Reilly ( <img src=/S/grin.gif border=0 alt=grin width=15 height=15> like Woody's v. useful "Annoyances" one), who I find usually strike the right balance in between the hand-holdy-idiot-guides and the know-it-all-already-doorstops.
    Goes into the Word object model (specifically document, range & selection objects), functions, variables, arrays, etc. (One appendix gives the Windows-API code calls for getting the installed printers from a word macro, which people always seem to be asking about in message borads such as this....)

  3. #3
    Silver Lounger Charles Kenyon's Avatar
    Join Date
    Jan 2001
    Location
    Sun Prairie, Wisconsin, Wisconsin, USA
    Posts
    2,048
    Thanks
    124
    Thanked 119 Times in 116 Posts

    Re: Book recommendations - VBA for word (2000/SR-1)

    Hi Susan,

    I've compiled a number of recommendations from the Microsoft Newsgroups on <A target="_blank" HREF=http://www.addbalance.com/word/wordbooks.htm> my books page</A> (addbalance.com/word/wordbooks.htm). Howard Kaikow who has forgotten more about VBA than I'm likely to ever learn has an annotated list as well (there is a link to it on my books page).

    Guy Hart Davis has written the which is Word-specific. If you can get your hands on his earlier <A target="_blank" HREF=http://www.amazon.com/exec/obidos/ISBN=078211962x/balancecheckbookA/> Word 97 Macro and VBA Handbook I would recommend doing so. I found its Part 1 (which is not continued in the Word 2000 version) to be extremely helpful although not about VBA. Entitled The Keys to Automating Word it was a lengthy overview of templates, styles, AutoText, AutoCorrect and other automatic features.

    Other Word-specific VBA books include , <A target="_blank" HREF=http://www.amazon.com/exec/obidos/ISBN=1861002556/balancecheckbookA/> Word 2000 Programmer's Reference, and Steve Roman's . You may also want to take a look at Woody's <A target="_blank" HREF=http://www.amazon.com/exec/obidos/ISBN=1565923081/balancecheckbookA/> Word 97 Annoyances which contains some VBA.

    Word is such a big and powerful program (despite its many flaws) that it is vital when programming it to have a thorough knowledge of what is already built-in. Otherwise I would spend days or weeks trying to reinvent a built-in feature such as wild-card replace.

    Because these books tend to be expensive (at least in my money frame) you may want to try getting a number of them through your public library system to look them over before buying them.

    Although books are invaluable, the only real way to learn VBA is by writing it. My other VBA links can be found on my . Look into the <A target="_blank" HREF=http://www.vbaoffice.com> VBAOffice site. Although it is subscription based, if you order a free issue of the magazine you also get about 45 days of free access to the website. This contains dynamite code with clear explanations. Also, I've found the <A target="_blank" HREF=http://www.mvps.org/word> MVP website</A> to be of great help.

    Note that the links given for specific books are to Amazon.com descriptions.

    Hope this helps,
    Charles Kyle Kenyon
    Madison, Wisconsin

  4. #4
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Book recommendations - VBA for word (2000/SR-1)

    See the list of Word VBA books at my URL below.

    Recently, I started a service for support of those learning and using Word macros. My first client chose to read 3 of the books on my list (she just added 4 more) and is sending me queries as she reads the books.

    It will be interesting to see which books help her most and, more importantly, WHY.

  5. #5
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Book recommendations - VBA for word (2000/SR-1)

    I forgot to mention.

    Since you have a programming background, I'd recommend starting with Steve Roman's book.
    It is more terse than the others, but then he's excused because he's a mathematician.

    In addition, ALL the beginning Word VBA books are inadequate. To learn the the guts of VBA, especially since you have a programming background, you should also get a good VB book such as Gary Cornell's Visual Basic 6 from the Ground Up.

  6. #6
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Fishburn, Durham, England
    Posts
    125
    Thanks
    0
    Thanked 0 Times in 0 Posts

    WOW - Spoiled for choice now!

    Thank you for all of your suggestions I will wade through them and see if I can get myself to the level of you other word gurus!

    I would also just like to state that I have read (from cover to cover) Woody's Word 97 Annoyances - I thought it was fabulous. It is the single book that developed my interest in using and understanding Word today. I fully endorse that book for anyone!

    I've bookmarked all the web sites pointed out to me and will let you know what I think of the books I get as I work through them.

  7. #7
    Silver Lounger Charles Kenyon's Avatar
    Join Date
    Jan 2001
    Location
    Sun Prairie, Wisconsin, Wisconsin, USA
    Posts
    2,048
    Thanks
    124
    Thanked 119 Times in 116 Posts

    Re: WOW - Spoiled for choice now!

    You are welcome. Please do post your impressions because they will be useful to many others. I would suggest you start a post for that purpose and revise it from time to time the way I have with the post on You might want to add it to the Books forum as well. With your permission I may add some or all of your impressions to my <A target="_blank" HREF=http://www.addbalance.com/word/wordbooks.htm> Word Books page.
    Charles Kyle Kenyon
    Madison, Wisconsin

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •