Recommend a second VBA book?

[jplank]

I'm looking for a book recommendation for someone who's already pretty familiar with vba and wants to go beyond the basics. A few years I bought John Walkenbach's Power Programming with VBA after seeing it recommended on a number of forums as a way to learn VBA. I've read through it and am looking for another more advanced book to use to improve my vba skills further. I've seen a lot of people recommend Professional Excel Development, but it looks like that book would be for people with more advanced vba skills than I have. So, I'm looking for a book that's more advanced than Walkenbach's Power Programming, but not quite as advanced as Professional Excel Development.

I've crossposted here (Recommend a second VBA book? - excel programming | Ask MetaFilter), but most of the responses aren't really what I'm after.

 

[SpillerBD]

That's a tough order.
I'm intrigued by some written by Richard Mansfield but haven't bought any of his. I kinda' thought the VBA for Office would be nice to see how to integrate with the other applications I use could work.
I am thinking of finding versions written for 2007 or older for discounted pricing, but much of the information and methods should still be good. Wiley press has some VBA books that look like college text-books based on pricing >$150 and I'm just not that serious (yet.)
While I am in accounting, I wonder if there are tools in "VBA for Modelers: Developing Decision Support Systems" by S Christian Albright that I could use. Sometimes a method used in one field is as or more useful in another.

 

[starl]

I can't imagine that John's book didn't teach you everything needed. Really, it's just a matter of practice. Reading forum threads can also teach because you learn different ways of applying logic, which is much harder to teach in a book. For example, you might be used to looping through a thousand rows to process the data. Another type of logic would be to dump that data into an array and process it there before dumping it back on the sheet. A good book teaches you both methods - looping on a sheet and working with arrays - but the "advanced" part of programming won't really teach how to consider which method to use.. that's experience (tho I'd do the data dump).

 

[RoryA]

For pure VBA, I don't think there's a better book than Getz/Gilbert's VBA Developers Handbook (Sybex).

 

[Kyle123]

I'll second Rory's suggestion - and emphasize the "For pure VBA" - there's not a lot of office in there! But brill book - I got my copy on Google play

 

[RoryA]

I got my copy on Google play

Definitely cheaper than getting it on Amazon currently! Almost tempted to sell mine there!