Could you please recommend a Excel/VBA book (considering that I am a proficient C++ and C# programmer) ?Something in between a book which assumes no programming knowledge and a book like "Professional Excel Development: The Definitive Guide to developing Application using Microsoft Excel and VBA"Thanks to all for your help.

If you are proficient in c++ and c# you could try books on vb 6.0 (vb. net is quite different from the older vb)If you don't want to bother with vba, try to get some info about doing add-ins in c++ applied to excel. also, try Matlab.VB syntax is very accessible.Cheers

Thanks BullBear.I came across "Writing Excel Macros with VBA, 2nd Edn. by Steven Roman".Maybe this suits me for getting started especially since it covers the VBE Editor Env / IDE.Thanks

I would also recommend John Walkenbach's "Excel 2003 Power Programmingwith VBA". I've found that what a good programmer needs for a new platformor programming model is a solid sequence of simple examples to get familiar with"how things are done" on the new platform. This book is great for that.

I don't know that book.But try to stay away from books with "Macros". What you need is pure VB our VBA applications and Excel. Writing functions, procedures, debugging, doing OOP stuff.If you are unfamiliar with excel, then try excel power programming or some other stuff.Maybe it's just me but "Macros" in Excel are not what you'll need the most. You need vba programming.Good luck

For a start, "Paul Wilmott Introduces Quantitative Finance" has lots of good simple examples using Excel and VBA, it's also a very good book. Then you could try one of the VBA books on Amazon, at least one of which I've seen is targetted at finance. It might just be accounts and what-not, but their books usually have user reviews so you'll get a good impression of what each book is useful for.

For Excel and VBA, the book by Mary Jackon and Mike Staunton (spursfan on Wilmott) is very popular.

There are some books in this list you may find useful https://www.quantnet.com/threads/master ... dents.535/

QuoteOriginally posted by: SkyhawkI would also recommend John Walkenbach's "Excel 2003 Power Programmingwith VBA". I've found that what a good programmer needs for a new platformor programming model is a solid sequence of simple examples to get familiar with"how things are done" on the new platform. This book is great for that.Thanks a lot. This books looks good for my background. Ordered it from amazon.

QuoteOriginally posted by: CDQNThere are some books in this list you may find useful http://www.quantnet.org/forum/showthrea ... Impressive compilation.

QuoteOriginally posted by: shettydiwakarCould you please recommend a Excel/VBA book (considering that I am a proficient C++ and C# programmer) ?Something in between a book which assumes no programming knowledge and a book like "Professional Excel Development: The Definitive Guide to developing Application using Microsoft Excel and VBA"Thanks to all for your help.you're saying this book is too advanced? have you got/read this book? it does cover some advanced topics, e.g. xlls, windows API calls etc, but also has a lot of easier stuff in as well, and if you're proficient in other languages you shouldn't have too much trouble. i'd recommend this one.

QuoteOriginally posted by: CuchulainnFor Excel and VBA, the book by Mary Jackon and Mike Staunton (spursfan on Wilmott) is very popular.Second that.

I just saw on amazon that "Excel 2007 Power programming with VBA" is the latest edition. So in case anybody is purchasing this book, go for the 2007 one. It also comes with an eBook.But anyway, there is not much difference between the 2003 I purchased and the 2007 edition.

i have the 2002 version in ebook, can give u if u want,

mit,Can you please share with me as well? Thanks! My email: yan.jiang7 @gmail.com