Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    USA
    Posts
    385
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Can anyone recommend a good general VBA reference book? Something that would cover VBA used in all the Office applications including example code.



    Thanks
    Richard

  2. Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    6,193
    Thanks
    201
    Thanked 784 Times in 718 Posts
    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

    VBA Rules!

    My Systems: Desktop Specs
    Laptop Specs


  4. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    USA
    Posts
    385
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Many thanks.
    This will help a lot.
    Richard

  5. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    5,895
    Thanks
    0
    Thanked 85 Times in 81 Posts
    For pure VBA, it's hard to beat the "VBA Developers Handbook" by Getz and Gilbert. It is worth its (considerable) weight in gold.
    Regards,
    Rory
    Microsoft MVP - Excel.

  6. #5
    Lounger
    Join Date
    Jun 2010
    Location
    Manchester, NH
    Posts
    34
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Got to agree with Rory's post. Since VBA hasn't really been revised for a number of years, this book is phenomenal.
    Bob Oxford
    Software Wizards, Inc.

Posting Permissions

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