Actuarial Outpost

Actuarial Outpost (http://www.actuarialoutpost.com/actuarial_discussion_forum/index.php)
-   Software & Technology (http://www.actuarialoutpost.com/actuarial_discussion_forum/forumdisplay.php?f=17)
-   -   Best way to learn VBA. (http://www.actuarialoutpost.com/actuarial_discussion_forum/showthread.php?t=88423)

chan_a 07-12-2010 08:24 AM

Microsoft has a very comprehensive VBA site. Take a look.

http://msdn.microsoft.com/en-ca/office/ff688774.aspx

bensonby2 01-29-2013 01:08 PM

There are lots of ways to learn VBA.

But to learn VBA well (and write good programs), I suggest learning another modern programming language first - having OOP and functional programming feature. It gives more solid programming concepts so you will be able to write VBA well.

actuary21c 11-09-2014 06:49 PM

Quote:

Originally Posted by bensonby2 (Post 6606304)
There are lots of ways to learn VBA.

But to learn VBA well (and write good programs), I suggest learning another modern programming language first - having OOP and functional programming feature. It gives more solid programming concepts so you will be able to write VBA well.

:iatp:

campbell 11-10-2014 05:14 AM

I saw someone make a similar answer on Quora recently, and their advice was to learn C++ as a language, as it underlies so many other modern languages, gives you object-oriented programming experience, and, besides, there are so many great resources for C/C++

actuary21c 11-10-2014 07:12 AM

Quote:

Originally Posted by campbell (Post 7769730)
I saw someone make a similar answer on Quora recently, and their advice was to learn C++ as a language, as it underlies so many other modern languages, gives you object-oriented programming experience, and, besides, there are so many great resources for C/C++

I wrote a lot in C++ before .net and C# came along. C++ is horrible to use because it requires (or at least it did the last time I looked at it) at least 2 files (a header and a body file) for each class. As I'm an object oriented developer, I create lots of classes, some of which are quite small. In C++ I would need hundreds of files, whereas in C# I only need one bit of code for each class, and I can put as many classes as I like into a single file. I end up with only about 5-10 files in C#, where I separate classes into different files for convenience/ease of classification rather than because the languages compels me to.

Bottom line for me: I choose C# over C++ every time. C++ is supposed to give you an extra 5% or so of performance but that's only if you want to use dirty, raw code (including pointers which are marked as unsafe in .net because you're on your own with memory management). Much better imho to write code in C# and then if you really need extra performance, optimise just the slowest bit (you can write that in C++ if you need to, but again there are probably other ways of optimising your first go with C# code).

campbell 11-10-2014 07:30 AM

I didn't say -use- C++ for anything real. Just learn it.

I don't use Lisp for anything, either, but learning it helped me think through some algorithmic stuff.

campbell 11-10-2014 07:35 AM

This is the analogy I forgot to mention: as the original answer said, if you want to learn/use Romance languages more deeply, learn Latin.

It's not that you're going to read or write in Latin for anything useful, but that it gives you a deeper understanding of the individual languages (and how they differ)

actuary21c 11-10-2014 08:22 AM

Quote:

Originally Posted by campbell (Post 7769844)
This is the analogy I forgot to mention: as the original answer said, if you want to learn/use Romance languages more deeply, learn Latin.

It's not that you're going to read or write in Latin for anything useful, but that it gives you a deeper understanding of the individual languages (and how they differ)

Good point, but imo it's still better to learn C# than C++: C++ has a lot of unnecessary overhead (header files, body files, interface definition language files) that really isn't needed to help someone learn good object oriented programming techniques. Microsoft did after all design C# as an improvement on both C++ and VB :)

AvidLearner 11-10-2014 08:29 AM

Googling and figuring things out on your own.

Programming was always quite intuitive to me, and to most actuaries I know.

campbell 11-10-2014 09:47 AM

Quote:

Originally Posted by AvidLearner (Post 7769893)
Googling and figuring things out on your own.

Programming was always quite intuitive to me, and to most actuaries I know.

Unfortunately, too many "intuitive" learners have just a mess for code, because they never learned it with any kind of discipline.


All times are GMT -4. The time now is 04:54 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.

Page generated in 0.26041 seconds with 9 queries