Results 1 to 8 of 8
  1. #1
    New Lounger
    Join Date
    Mar 2004
    Location
    Arlington, Virginia, USA
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    VBA Programming with Excel Reference Book (2000 9.0.3821 SR-1)

    I'm looking for recommendations on the best reference book for VBA programming with Excel.

    Thanks,

    Wally

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: VBA Programming with Excel Reference Book (200

    John Walkenbachs Power programming with VBA is very good expecially if you are learning VBA.

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA Programming with Excel Reference Book (2000 9.0.3821 SR-1)

    I like this one too:

    Excel 2000/2002 VBA Programmers Reference. Stephen Bullen, John Green, Rob Bovey, Robert Rosenberg. Wrox Press.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  4. #4
    3 Star Lounger
    Join Date
    Jan 2004
    Location
    Birmingham, West Midlands, United Kingdom
    Posts
    219
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA Programming with Excel Reference Book (2000 9.0.3821 SR-1)

    And if, as I rather doubt, you're starting from minus infinity (like me), John Walkenbach's 'Excel Programming for Dummies' is hugely readable, and as far as I can see, True.

  5. #5
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Vancouver, Br. Columbia, Canada
    Posts
    268
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: VBA Programming with Excel Reference Book (2000 9.0.3821 SR-1)

    I would second the recommendation for John Walkenbach's Excel 2002 Power Programming with VBA - it starts at a comfortable pace for somebody with limited experience, but gets to a pretty solid level. Other suggestions:
    <UL><LI> I would specifically NOT recommend Excel 2000 VBA Fundamentals by Reed Jacobson (Microsoft Press); it is far too simple-minded, and the programming examples are trivial and artificial.
    <LI> Excel 2000/2002 VBA Programmers Reference Stephen Bullen, John Green, Rob Bovey, Robert Rosenberg. Wrox Press (as suggested by Jan Karel) - also a very good book, but I think better suited either for a (fairly) experienced programmer (in any language) or someone who has done a bit of VBA programming before.
    <LI> The Definitive Guide to Excel VBA Micheal Koffler, A-Press. This is comprehensive, but I didn't learn much (if anything) that I hadn't already seen in the Bullen or Walkenbach books. I was disappointed with this book: the author is German, and sometimes the translation gives this away in the word-order or phrasing. As well, all the screen-shots are blurry, and the author (or translator) uses unconventional terminology for VBA Arrays (refers to them as "fields") - while what he says about using arrays is correct, I found this to be a little jarring. Even with a fair degree of familiarity with VBA, I found this book to be very unapproachable - material is presented without (to my mind) enough context about why certain constructs or processes might be useful - and I already knew why some of this stuff was important. For a learning user, I think it would be a daunting introduction.
    <LI> I have not read Walkenbach's Dummies book - my experience with the Dummies series is that you outgrow them very quickly, although they are a very gentle introduction - I guess it depends on how high your aspirations are, and how determined you are to continue the learning process. I should add the caveat that I think Walkenbach is one of the best of the Excel authors[/list]In summary, I found the Walkenbach book a very good introduction, through to mid/advanced user - but it is the Bullen book I keep at work, in the shelf above my monitor <img src=/S/grin.gif border=0 alt=grin width=15 height=15>. No doubt, your mileage may vary...

  6. #6
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    New York, New York, USA
    Posts
    266
    Thanks
    0
    Thanked 19 Times in 19 Posts

    Re: VBA Programming with Excel Reference Book (2000 9.0.3821 SR-1)

    A book I though was very good was Learn Microsoft Excel 2000 VBA Programming by Julitta Korol published by Wordware Publishing Inc. http:www.wordware.com.

    I very much liked the way it was organized to allow the reader on the fly to quickly find what is needed. It starts from the very basic and goes to the more complex.
    If you just want to get the work done buy it. If you want to know everything about Excel VBA you will need a different book. Good luck.

    TD

  7. #7
    New Lounger
    Join Date
    Mar 2004
    Location
    Arlington, Virginia, USA
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA Programming with Excel Reference Book (2000 9.0.3821 SR-1)

    Thank you all for your suggestions. I placed an order for John Walkenbach's Excel 2002 Power Programming with VBA.

    Wally

  8. #8
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: VBA Programming with Excel Reference Book (2000 9.0.3821 SR-1)

    I also like the structure of her book, suitable for Excel VBA beginners and intermediates.
    -John ... I float in liquid gardens
    UTC -7ąDS

Posting Permissions

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