×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Any good references?
2

Any good references?

Any good references?

(OP)
I was wondering if anyone knows of a good reference book for VBA, especially as it relates to Excel (and/or Access).  Is there a general reference book (not application specific) that is a must-have?


RE: Any good references?

If you are interested in the ULTIMATE VBA reference for Excel, go for a John Walkenbach Book. Most of the VBA techniques I know comes from there. The man knows the application inside out and he has a captivating style of writing. In his book you'll find things the Redmond chaps didn't have the vaguest idea about until John said so.

By virtue of the fact that each of the applications using VBA as their programming language has its own unique set of objects/properties/methods apart from some which are common across applications, it is unlikely you'll find a useful general VBA referance book - and all application-specific books give you a comprehensive treatment of the general VBA language philosophy.

Good luck
mala
mala_rs_singh@rediffmail.com

RE: Any good references?

You cannot get away just with one book. I found the best discussion of how to use external databases, DAO and SQL in "MS Excel 97 Developer's Handbook" by Microsoft Press, authors Eric Wells and Steve Harshbarger. It also contains a concise description of basic VBA and much more.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources