VBA Book Recommendation (not a question)

[stuartw]

Hi All

I noticed there are a lot of posts that start with "I'm new to VBA...." (me being the author of some of them) so I thought I'd share a book recommendation with you. I'm not normally a fan of the "For Dummies" series but if you are pretty proficient at Excel and you'd like to take your skills to the next level I would highly recommend "Excel 2007 VBA Programming for Dummies" by John Walkenbach.

If the immortal sentence "this can be done with code" makes you want to give up then it's a must read.

I've been using it for a couple of weeks and I haven't put it down - easy to read and "fun" (if you like that sort of thing).

Toodle oo for now.

Stu

 

[geo09]

I share your view on this...
It is an easy book and well built. Lots of small concrete examples.

 

[stuartw]

If there are any mods out there reading this was wondering if it might be useful to have a recommended reading list made sticky? Helping people to help themselves being the idea.

 

[jmckeone]

Curious if that book includes an issue I ran into just this past week; when it is better to use Excel features than code. I spent two or more days working on a complex bit of code to loop through masses of data and the processor hit was overwhelming to the point it wouldn't run to completion. I post the issue to the board and someone tells me "a pivot table will do that". Two minutes later I had the desired effect.

 

[Fazza]

I worked somewhere a few years ago and somebody had a large amount of data on a worksheet and then about 30 more worksheets reporting on that data. I'd estimate it took 3 months to set up. Who knows if it was even correct? A pivot table or two replaced the 30 worksheets and three month's work in, like you said, two minutes. And it was a superior, accurate & flexible solution. The guy was amazed to learn how easy it was, and that Excel has had pivot table since ~mid 90s.

 

[Fazza]

PS My favourite link for pivot tables http://www.datapigtechnologies.com/ExcelMain.htm