Advise on best books, please.

[kins]

Hi,


I'm looking to buy a couple of books and I'd like peoples advice on which they think are the best.

I want a starters guide to writing VBs. I have no experience, so I need a book that will start me off from scratch and talk me right through. Also, does it matter if the book's for 2008 or 2010, if my excel at home if neither? Or do I have to get a book for the same excel I have at home?

I also want an excel book. I've done an advanced excel course, but I need to widen my excel skills. So could anyone recommend a good excel book that will teach me new formulas and also help me to interprit complex excel formulas.


Thanks in advance for any advise.

Kins

 

[Derek Brown]

It would be useful to know which version of Excel you have at home.
I guess that you meant 'VBA' (Visual Basic for Applications) instead of VBS (VB Script) and '2007' instead of '2008'.

 

[kins]

It would be useful to know which version of Excel you have at home.
I guess that you meant 'VBA' (Visual Basic for Applications) instead of VBS (VB Script) and '2007' instead of '2008'.

hi derek, thanks for the response. it'll be excel 2007.
when i wrote VBA, i didn't actually intend to distinguish between VBA or VBS, as I didn't know there was any difference - hence why I need a book for beginners.

bascially, the VB book i need, needs to be something that starts me off from the very beginning and explains everything to me.

in terms of the excel book, i'm more than competent with vlookup, sumiof, pivots etc. i just need to go to the next step and learn formula that have multi functions in them. I also want to be able to have the ability to translate existing formulas that i might come across.

Thanks,

Kins

 

[Derek Brown]

Did you see the earlier post in this forum:
http://www.mrexcel.com/forum/showthread.php?t=573302
Have a look at those and also check out the MrExcel store:
http://www.mrexcel.com/store/index.php
If you want to look at book reviews, have a look for the book on Amazon and see if there are any reviews for the ones that interest you.
Remember that there were big changes from Excel 2003 to 2007 and some new features in 2010.

 

[kins]

thanks for the above, derek. admittedly, i've been somewhat lazy and not really search the forum. i will look at the links you have provided.

thanks for your help, i appreciate it.

Kins

 

[NiceGuyRitchie]

SAMs Teach Yourself guides are the best I've found to date. With discipline and practice, this book can take you from beginner to intermediate to advanced in a fairly short time. I was one month into the VB book and by then had half of my reports automated.

http://www.amazon.com/Teach-Yourself-Visual-Basic-Applications/dp/0672310163

Lessons are incremental and hands on, this is not another bloated reference manual.

Best of Luck!

 

[Smitty]

John Walkenbach's Power Programming with Excel VBA books are great: www.j-walk.com.