Any good references? 2

[ivymike]

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?

 

[Mala]

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

 

[yakpol]

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.

 

[SBaugh]

Try these Excel and VBA Websites:

http://geocities.com/aaronblood/menu.html

http://www.vbapro.com/

http://www.barasch.com/excel/xlvba.htm

http://www.shef.ac.uk/training/scot/excel.htm

http://www.bmsltd.co.uk/mvp/

http://www.j-walk.com/ss/excel/index.htm

http://www.mindspring.com/~tflynn/vbalinks.html

Hope that helps, Scott Baugh, CSWP
George Koch Sons,LLC
Evansville, IN 47714
sjb@kochllc.com