

FlashChat  Actuarial Discussion  Preliminary Exams  CAS/SOA Exams  Cyberchat  Around the World  Suggestions 
View Poll Results: What is the best way to learn VBA?  
Book  107  36.27%  
Help  48  16.27%  
Internet  147  49.83%  
Macro Recorder  112  37.97%  
Multiple Choice Poll. Voters: 295. You may not vote on this poll 

Thread Tools  Display Modes 
#52




Quote:
http://www.casact.org/dare/index.cfm...w&abstrID=3400 Brad
__________________
Brad Gile, FSA, MAAA Affiliate Member of the CAS Dedicated Retired Actuary Spoiler: Spoiler: 
#53




Quote:
My thoughts exactly!
__________________
Carol Marler, "Just My Opinion" Pluto is no longer a planet and I am no longer an actuary. Please take my opinions as nonactuarial. My latest favorite quotes, updated Sep 18, 2017. Spoiler: 
#54




I have programmed them, never used them in practice.
I find they are to hard to fit. And Shaun Wang's papers in general are a must read IMO. (Though I have never seen this one, thanks!) 
#55




I'm in the process of learning VBA right now. I have bought an online selfpaced bundle of desktop applications that include Access, Excel, VBA, and others.
The lesson format gives you the choice of full tutotiral, guided, or let me try. The let me try has the option of a hint button if you get stuck. After the main lesson, a multiple choice quiz is given at the end. After using Excel in an internship without any formal training, I love these tutorials. 
#56




Quote:

#57




I am learning how to use Excel VBA. So far, it seems, well,...rudimentaryin comparsion to what I know how to do with Mathematica. But it's clear that you can create nonmathematical programs in VBA, and if the industry is expecting it as part of my skill set, then so be it.
Some time ago I wrote a Mathematica program that solved Sudoku puzzles through recursive application of rulebased manipulation and process of elimination, much in the way that humans dorather than by brute force guessing. Mathematica also has better handling of numerical erroryears ago, I once tried to do a nonlinear fit in Excel that resulted in a numerically unstable result, whereas Mathematica did it perfectly. I should hope Excel has evolved since then to handle such situations better. I wonder why Mathematica is not used in the actuarial field...? Is it the price? Is it the lack of relevance? Is it because Excel is used by nonactuarial sectors to visually organize and manipulate data?
__________________
Spoiler: 
#58




For things like nonlinear fits, I would recommend using SAS or something similar. I think of using Excel in actuarial field as mostly a nice way to present / summarize data. Just like I would use access for database manipulation and SAS (or something similar) for heavy duty statistics. I think Mathematica is expensive (probably on par with SAS so that's not really a good argument) but I don't know of any statistical task that SAS can't do but Mathematica can (not sure about vice versa).

#59




I just discovered that if I put the cursor on a word in my VBA program (e.g. GetFileName) and press F1, the help screen regarding that method/function/object/whatever comes up.
This is much faster than digging through the help for language reference  methods  G  GetFileName. Or, just type a keyword temporarily and backspace and hit F1 to quickly get help about it. 
#60




Quote:
Brad
__________________
Brad Gile, FSA, MAAA Affiliate Member of the CAS Dedicated Retired Actuary Spoiler: Spoiler: 
Thread Tools  
Display Modes  

