PDA

View Full Version : [SOLVED] VBA Book recommendation



SailFL
08-09-2005, 11:35 PM
I am learning to code VBA and will be creating some code for a specific application that will be updating master workbooks from individual excel sheets. I want to add additional functionality. I am learning a lot just by reading the post here.

I also am no stranger to coding. I have 15 years experience coding in numerous languages like C, C++, Java, Ada, Fortran etc.

I don't need to understand how to code and the basic structures of programming but understanding the VBA capabilities.

I am open to suggestions.

Thanks

Zack Barresse
08-10-2005, 08:30 AM
Hi SailFL! :006: How are you?

I would suggest 'VBA and Macros for Microsoft Excel (http://www.google.com/url?sa=t&ct=res&cd=3&url=http%3A//www.mrexcel.com/vbabook.html&ei=xxv6Qs-tCsT2YPeV2eAJ)', 'Excel 2000 Power Programming with VBA (http://j-walk.com/ss/books/bookxl12.htm)', Excel 2003 Power Programming (http://www.dummies.com/WileyCDA/DummiesTitle/productCd-0764540726.html)' (the 2000 is still good though, but the 2003 is newer, both by J-Walk), 'Microsoft Excel 2003 Programming [Inside Out] (http://www.amazon.com/exec/obidos/tg/detail/-/0735619859/102-9203976-7500913?v=glance)', Professional Excel Development (http://www.amazon.com/exec/obidos/ASIN/0321262506/excelbusiness-20/102-9203976-7500913)' (more geared towards spreadsheet design), 'Excel VBA Programming for Dummies (http://www.amazon.com/exec/obidos/ASIN/0764574124/excelbusiness-20)' and 'Mastering Excel 2003 Programming with VBA (http://www.amazon.com/exec/obidos/ASIN/0782142818/excelbusiness-20)'.

I've got a copy of the 'VBA and Macros for Microsoft Excel' by Bill Jelen and Tracy Syrstad; great book. Check out the Book Reviews (http://www.vbaexpress.com/forum/forumdisplay.php?f=75) forum for some additional information on them.

HTH

Ken Puls
08-10-2005, 08:51 AM
Hi SailFL!

I woudl recommend John Walkenbach's "Power Programming With VBA" series, hands down. I have had the 2002 version for a couple of years now, and still refer back to it. There is a HUGE amount of info in there, and it is written very well to not be overwhelming to a new programmer, and yet still has a ton of information for the advanced programmer as well.

Honestly, can't say enough about that book. I usually buy my books from the clearance table when a new version comes out. This one I paid top dollar for, though, on the recommendation of a friend, and it was worth far more than what I paid for it.

My impression: You want to learn VBA? Go J-Walk! :yes

Bob Phillips
08-10-2005, 09:01 AM
Well, seeing as it's a party, I'm joining.

Excel 2002 VBA Programmer's Reference
Author(s): John Green
Rob Bovey
Stephen Bullen
Robert Rosenberg
Format: Paperback, 2nd ed., 600pp.
ISBN: 1-861005-70-9
Publisher: Wrox
Pub. Date: September 2001

Synopsis This book presents a full reference to the Excel object model, which is essentially the object-oriented system of organizing the functional capacities that make up the Excel program. There is a short introduction to VBA itself, and the rest of the book documents aspects of programming Excel through that object model.
Level: Intermediate/Advanced
My view: The only 'Excel' book in the list.

In my view there are not many good Excel books around, too many re-hash the same old stuff which most intelligent Excel users are perfectly capable of acquiring from their own skills. But this one goes beyond all of that, it's about programming. I often say to people that VB is easy, it's understanding the various object models that is difficult and where the power lies. This book takes you through the Excel object model, and show you many great techniques to harness it for your code. The Object Model Reference is quite handy too!

And you get a nice picture of Stephen Bullen and John Green :).

Avoid the 2003 version though, the edit has been done very badly IMO.

Zack Barresse
08-10-2005, 09:06 AM
Ah! Knew I was forgetting a book Bob! You should write that up in the Book Reviews forum.. ;)

Ken Puls
08-10-2005, 09:08 AM
And you get a nice picture of Stephen Bullen and John Green :)

:rotlaugh: The most ringing endorsement ever! LOL!

Thanks for joining the party, Bob!:beerchug: I've never purchased that one, but I have to say that you've got me thinking it might be worth a read some day as well. Can never have too much info!

Zack Barresse
08-10-2005, 09:31 AM
I've picked it up at Barnes and Nobles (on one of my all-day excursions .. LOL) and it is an excellent book. Really has a good grasp on the Excel Object Model and puts it in good perspective with easy to follow material. A great book by some extremely knowledgable authors. :yes

Bob Phillips
08-10-2005, 09:32 AM
The most ringing endorsement ever! LOL!

As I said Ken, it is the only Excel book I have ever bought (tons of VB, COM, API, but just one Excel), so there had to be something. Actually, I bought the 2000 version and the 2002 version is even better (shame about the 2003).

Bob Phillips
08-10-2005, 09:39 AM
I've picked it up at Barnes and Nobles (on one of my all-day excursions .. LOL) and it is an excellent book. Really has a good grasp on the Excel Object Model and puts it in good perspective with easy to follow material. A great book by some extremely knowledgable authors. :yes

Wow, I am impressed by a man that doesn't hesitate!

For interest Zack, two other great books (which I don't own yet, I am looking for bargains) are

VBA Developers Hanbdook (http://www.amazon.com/exec/obidos/tg/detail/-/1590590260/qid=/br=1-/ref=br_lf_b_//103-0580442-3103803?v=glance&s=books&n=10405891)
by Ket Getz & Mike Gilbert
Sybex International

and

Doing Objects in Microsoft Visual Basic 6 (http:///exec/obidos/ASIN/1562765779/qid=1123691718/sr=1-3/ref=sr_1_8_3/202-4558259-8580646)
~Deborah Kurata
Sams
Paperback - July 1998

The second is more generic, but makes for a good read.

And of course, if you want hard-core stuff

Hardcore Visual Basic
Bruce McKinney
Paperback, 2nd ed., 760pp.
1-572314-22-2
Microsoft Press
July 1997

Advanced Visual Basic 6: Power Techniques for Everyday Programs
Matthew Curland
Paperback, 2nd ed., 528pp.
1-201707-12-8
Addison-Wesley
July 2000

The McKinney book went out of print years ago, I picked mine up from a street vendor. He had 6, I wished I had bought them all. But beware, these are not bedtime reading.

Bob Phillips
08-10-2005, 09:49 AM
Professional Excel Development (http://www.amazon.com/exec/obidos/ASIN/0321262506/excelbusiness-20/102-9203976-7500913)' (more geared towards spreadsheet design)

Zack,

Interested by that comment. I don't have the book (was hoping to get a free one, but too late to that party :doh:), and only glanced at it in a shop, but I thought it was geared at Excel applications, intrinsically requiring VBA, not spreadsheet design. Agreed, the spreadsheet design is a fundamental of a good application, but I didn't think it was primarily aimed there.

And of course, it is probably more advanced than SailFL needs at this point.

Ken Puls
08-10-2005, 10:03 AM
... thought [Professional Excel Development (http://www.amazon.com/exec/obidos/ASIN/0321262506/excelbusiness-20/102-9203976-7500913)] was geared at Excel applications, intrinsically requiring VBA, not spreadsheet design.

I haven't read all of it yet. After about chapter 6, it ceased being bedtime reading! :rotlaugh: The first few chapters are specifically based on good spreadsheet modelling, and after that it went into some heavy code. I'm only up to around chapter 8 or so, though, so don't know what the rest holds.

Zack Barresse
08-11-2005, 09:28 AM
.. I think I should have said, good spreadsheet design integrated with good structured code. Of course, XL-Dennis' write up (http://www.vbaexpress.com/forum/showthread.php?t=2189) on it is much better. :yes

Ken Puls
08-11-2005, 09:39 AM
.. I think I should have said, good spreadsheet design integrated with good structured code.

Wouldn't that be well structured code? I you think that the way you said it is gooder though, that's okay with me! :p

Zack Barresse
08-11-2005, 09:42 AM
As long as it's okie dokie with Ken, then I am bestest with it. :D

SailFL
08-11-2005, 10:22 AM
Thank you to all for the excellent suggestions. I think I can mark this as solved unless you want to continue to add your comments.

Ken Puls
08-11-2005, 10:54 AM
Hi SailFL,

If the thread is solved to your satisfaction, then by all means, please mark it so. :)

So you know, everyone can still post to a solved thread if they have more input. It's just a way of keeping our coders focussed on issues that are still outstanding.

Cheers!