best book to learn VBA

[Tom F]

What book have you found to be the best to learn VBA and why?

Thanks,
Tom

 

[mikerickson]

"Excel VBA Programming for Dummies" is a different book than "VBA for Dummies".
I haven't read "Excel VBA Programming for Dummies" that Richard recommended, but I don't think much of "VBA for Dummies."

 

[Tom F]

mickericson,

I've had an exposure to BASIC programming years back. The "dummy" book route sounds like a good starting point.

Thanks for all the posts. This board is awesome!

Tom

 

[SydneyGeek]

I don't think much of "VBA for Dummies."

I bought this a while ago, and I agree. It's pretty good as a structural book on VBA, but if you want to use it for Excel, there's much better material about. However, it's not bad if you are trying to work out how to program in Visio (which is where many of the samples are targeted).

Denis

 

[Tom F]

Just wondering ... is the 2007 Excel version compatible to the 2003 Excel version as far as VBA code or will they be different?

Thanks,
Tom

 

[Richard Schollar]

There are differences (Application.FileSearch has been removed in 2007 for example, among others). Many of the differences will likely relate to the different ways of doing things eg Pivot Tables and file formats in 2007 compared to 2003. The structure of the VBA language is pretty much unchanged though.