Page 1 of 2 12 LastLast
Results 1 to 15 of 26
  1. #1
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    Pittsford,NY
    Posts
    711
    Thanks
    318
    Thanked 26 Times in 20 Posts

    Newbie to VBA needs good book recommendations

    I'm a retired systems programmer and application programmer from way-back in IBM mainframe days.
    Back then, Cobol and such were verb-oriented (Move X to Y, for example.)

    In trying to teach myself VBA, I cant seem to get my head around object-orientation, which is a different
    way of approaching things.

    Can anyone recommend a good book or two for someone like myself, so that I can break through this
    mental road-block?

    Any suggestions will be gratefully received.

    Thanks,
    Dick

  2. The Following User Says Thank You to Dick-Y For This Useful Post:

    mfa (2012-01-12)

  3. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    6,474
    Thanks
    211
    Thanked 848 Times in 780 Posts
    Dick,

    There are tons of books on VBA and most are specific to the program (Access, Excel, Word, etc.) that you want to use it with. The thing you have to remember is that VBA consists of 2 parts. Part 1 is the control structures, If-Then-Else, For x to y, For Each, While-Loop, etc. That is the same in all products. Part 2 is the Object Model, i.e. the objects you will be working with which is of course specific to each product, e.g. Paragraphs, Sentences, etc. in Word; Workbooks, Worksheets, Rows, Columns, Cells, etc in Excel; Tables, Queries, Forms, Reports, etc. in Access.

    So if you have a product in mind I and others here can give you more useful advice on which books to get. For general knowledge I'd recommend, no slight intended in view of your background, VBA for Dummies. It's on my book shelf and I've been programming apparently as long as you and I also had a problem initially getting my head around object orientation and still do from time to time.

    In any case good luck in your journey.
    May the Forces of good computing be with you!

    RG

    VBA Rules!

    My Systems: Desktop Specs
    Laptop Specs


  4. #3
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    Pittsford,NY
    Posts
    711
    Thanks
    318
    Thanked 26 Times in 20 Posts
    Thanks RG. I'm wanting to write VBA code in Excel (currently 2007.)

    Dick

  5. #4
    Plutonium Lounger Medico's Avatar
    Join Date
    Dec 2009
    Location
    USA
    Posts
    12,625
    Thanks
    161
    Thanked 932 Times in 853 Posts
    Dick, I wonder if a site such as this would be helpful. I simply did a Google search of VBA in Excel.
    BACKUP...BACKUP...BACKUP
    Have a Great Day! Ted


    Sony Vaio Laptop, 2.53 GHz Duo Core Intel CPU, 8 GB RAM, 320 GB HD
    Win 8 Pro (64 Bit), IE 10 (64 Bit)


    Complete PC Specs: By Speccy

  6. The Following User Says Thank You to Medico For This Useful Post:

    Dick-Y (2011-12-21)

  7. #5
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    Pittsford,NY
    Posts
    711
    Thanks
    318
    Thanked 26 Times in 20 Posts
    Ted:
    Thanks. That looks to be just what I need.
    Dick

  8. #6
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    6,474
    Thanks
    211
    Thanked 848 Times in 780 Posts
    Dick,

    Ok, here's the Excel VBA stuff in my library:
    1. "Excel 2000 {of course you'll get the latest}Power programming with VBA", Walkenbach.
    2. "Writing Excel Macros", Steven Roman - O'Reilly
    3. "Professional Excel Development", Gullen, Bovey, Green - Addison Wesley
    4. "Special Edition Using Excel Visual Basic for Applications 2ed", Webb - Que

    You'll probably want the latest versions of these but you can get used copies at substantial discount and things haven't changed all that much, at least from a learning standpoint. Of course, there is always new stuff but It's the basics you want in the beginning.
    May the Forces of good computing be with you!

    RG

    VBA Rules!

    My Systems: Desktop Specs
    Laptop Specs


  9. The Following User Says Thank You to RetiredGeek For This Useful Post:

    Dick-Y (2011-12-17)

  10. #7
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    5,938
    Thanks
    0
    Thanked 94 Times in 90 Posts
    FWIW, once you get past the beginner stage, this is the best book on pure VBA that I have ever come across.
    Regards,
    Rory
    Microsoft MVP - Excel.

  11. #8
    Administrator
    Join Date
    Jun 2010
    Location
    Portugal
    Posts
    10,396
    Thanks
    131
    Thanked 1,167 Times in 1,071 Posts
    Quote Originally Posted by rory View Post
    FWIW, once you get past the beginner stage, this is the best book on pure VBA that I have ever come across.
    Interesting that you bring up that book. I have the two volumes for Access 2000, Ken Getz co-authored them and they are also the best books on Access that I ever had access to. It also covers some VBA, of course, even automation.

    It's a shame that they never updated either set of books for Office versions later than 2000, even if most of the contents are still usable with the current Office version.

  12. #9
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    5,938
    Thanks
    0
    Thanked 94 Times in 90 Posts
    They were updated for Office XP as best I recall, but not subsequently. Perhaps there simply weren't enough changes to merit a rewrite.
    Regards,
    Rory
    Microsoft MVP - Excel.

  13. #10
    Administrator
    Join Date
    Jun 2010
    Location
    Portugal
    Posts
    10,396
    Thanks
    131
    Thanked 1,167 Times in 1,071 Posts
    Quote Originally Posted by rory View Post
    They were updated for Office XP as best I recall, but not subsequently. Perhaps there simply weren't enough changes to merit a rewrite.
    You are right, they did it for Access 2002.

    Would be great to have them for Office 2010 or 2012. A few versions have gone by probably making the update worthy.

    These are among the best technical books I ever bought.

  14. #11
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    5,938
    Thanks
    0
    Thanked 94 Times in 90 Posts
    Couldn't agree more. I think I probably learned more from those three books than from all my other books combined (possibly excluding PED, or Dan Appleman's API guide).
    Regards,
    Rory
    Microsoft MVP - Excel.

  15. #12
    2 Star Lounger HiTechCoach's Avatar
    Join Date
    Sep 2011
    Location
    Oklahoma City, OK
    Posts
    162
    Thanks
    0
    Thanked 24 Times in 24 Posts
    This may be an old book but it helps you make the transition. And you can get is used for less than $1 + shipping. What a deal.

    Visual Basic for Cobol Programmers/Book and Disk
    Boyd Trimmell aka HiTechCoach (Access Information here)
    Microsoft MVP - Access Expert
    "If technology doesn't work for people, then it doesn't work."

  16. The Following User Says Thank You to HiTechCoach For This Useful Post:

    Dick-Y (2011-12-21)

  17. #13
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    Pittsford,NY
    Posts
    711
    Thanks
    318
    Thanked 26 Times in 20 Posts
    Thanks! I just ordered a used copy for 50 cents, plus shipping.
    It looks to be just what I need.

    Dick

  18. #14
    New Lounger afrolick's Avatar
    Join Date
    Dec 2011
    Location
    Rolla, MO
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Post Pointy Haired Dilbert

    I'm new around here but I myself, Like http://chandoo.org/wp/ He teaches all aspects of Excel.

    Hope that helps ya, Allan

  19. #15
    Super Moderator
    Join Date
    Dec 2000
    Location
    New York, NY
    Posts
    2,970
    Thanks
    3
    Thanked 28 Times in 27 Posts
    Allan,

    Welcome to the Lounge, and thanks for the link - that is a good site.

    Gary

Page 1 of 2 12 LastLast

Posting Permissions

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