Serving the Quantitative Finance Community

 
User avatar
patch22
Posts: 0
Joined: May 9th, 2002, 7:50 am

Best way to learn VBA

October 30th, 2002, 7:30 am

No not diffcult its very clearly written although dont expect it to be a quick read, the full OOP implementation of C++ is I think a big subject requiring a big book.
 
User avatar
J
Posts: 1
Joined: November 1st, 2001, 12:53 am

Best way to learn VBA

October 30th, 2002, 5:28 pm

patch22,I will use ILL to borrow that book you say. Is it very dry i.e. not interesting?
 
User avatar
J
Posts: 1
Joined: November 1st, 2001, 12:53 am

Best way to learn VBA

November 20th, 2002, 2:01 pm

patch22,Have you got my sent private message ?
 
User avatar
sparky3223
Posts: 0
Joined: May 2nd, 2002, 5:15 pm

Best way to learn VBA

November 20th, 2002, 6:59 pm

For C++ the de facto standard text in american university is "C++ How to Program" by Deitel and Deitel. Most college will use this book as a starting point in teaching C++.Besides having tons of example, it is also a good reference.
 
User avatar
J
Posts: 1
Joined: November 1st, 2001, 12:53 am

Best way to learn VBA

November 20th, 2002, 8:34 pm

sparky3223,Does "C++ how to program?" cover STL? Does "C++: how to program" tell me everything I need to know without having a computer in front of me?
Last edited by J on November 19th, 2002, 11:00 pm, edited 1 time in total.
 
User avatar
J
Posts: 1
Joined: November 1st, 2001, 12:53 am

Best way to learn VBA

November 20th, 2002, 8:54 pm

NA
Last edited by J on November 19th, 2002, 11:00 pm, edited 1 time in total.
 
User avatar
sparky3223
Posts: 0
Joined: May 2nd, 2002, 5:15 pm

Best way to learn VBA

November 20th, 2002, 9:51 pm

J, yes, but only if you have an photographic memory. The text is very good in terms of providing you the code and then the actually output. It would be hard to learn C++ without having a computer in front of you. It's one of the things you learn by experience. The books covers STL at the very end of the book. It shows you how to implement some of the STL, such as mergesort and quicksort.Since it was never covered in college, and I only briefly read through those chapters. And I have to say, it's been a really long since I used the book. (less than 3 years ago) One of these days I will have to go back and re-learn OOP again. The other text on C++ to get is written by the creator himself, Bjarne Stroustrub, "The C++ Programming Language." Also, J, seems like you are coming from vba + matlab background? I am the opposite, learned C++ first and then now trying to learn vba. The 2nd edition that I have used only covered programming in the dos environment. I haven't looked at the recent editions, since they started covering other stuff. http://www.amazon.com/exec/obidos/ASIN/ ... 5447Amazon link
Last edited by sparky3223 on November 19th, 2002, 11:00 pm, edited 1 time in total.
 
User avatar
foxx
Posts: 0
Joined: October 30th, 2002, 1:08 pm

Best way to learn VBA

November 21st, 2002, 8:51 am

I noticed Paul Wilmott's book has a CD with VB code for his models -- might be a good way to learn VB if you already have some programming experience?I recommend Sam's Teach Yourself C++ in 24 hours for the C++ beginner. It's not a comprehensive guide to the language, but it will give you a working knowledge pretty quickly.
 
User avatar
AthleteScholar
Posts: 0
Joined: December 4th, 2002, 4:16 am

Best way to learn VBA

March 15th, 2003, 6:16 am

Hi, is it better to learn VB first, then VBA? (maybe there is no difference between both of them? ) I'm getting confused because the topic is "Best Way to Learn VBA"...but, why some recomanded the "Sam teach Yourself VB 6 in 21 Days"? Thanks!!!
 
User avatar
montecarlo
Posts: 1
Joined: November 7th, 2002, 12:42 pm

Best way to learn VBA

March 15th, 2003, 3:47 pm

QuoteOriginally posted by: AthleteScholarHi, is it better to learn VB first, then VBA? (maybe there is no difference between both of them? ) I'm getting confused because the topic is "Best Way to Learn VBA"...but, why some recomanded the "Sam teach Yourself VB 6 in 21 Days"? Thanks!!!I always thought VB was VBA??? not i'm confused with that.. VB is the environment isn't it, and VBA is the language? someone please correct me.and VB6, visual basic 6 is the package which encompasses VBA... right?
 
User avatar
AthleteScholar
Posts: 0
Joined: December 4th, 2002, 4:16 am

Best way to learn VBA

March 16th, 2003, 1:42 am

QuoteOriginally posted by: dcI like the <i>VBA for Modelers </i> book best. If you want to shell out more cash, there are some online training programs available - such as <a target=new class=ftalternatingbarlinklarge href="http://www.ozgrid.com/">OzGrid.com</a>.Does anyone else know any other (Cheaper) online training courses for Excel VBA besides the ozgrid one? Maybe some have discounts for students? THANKS!!!
 
User avatar
king
Posts: 0
Joined: March 24th, 2002, 2:56 pm

Best way to learn VBA

March 16th, 2003, 5:38 am

VBA is a subset of VB.They are both very easy to learn i.e. they can be self taught.
 
User avatar
Flex
Posts: 2
Joined: December 19th, 2002, 9:32 am

Best way to learn VBA

March 17th, 2003, 1:33 pm

I disagree with VBA being a subset of VB. Moreover it is the same basis language, but while VBA (Visual Basic for applications)is designed for a special appliction (let's say excel, or access), VB is a general programming language.Imo, if you only need to learn VBA for a special application (let's say again excel), it is sufficient to only handle a goodVBA book.On the other hand, if your interested in VB in general, you should learn VB. Learning VBA for a special application is then no big task (having some literature on the hand).Flex