![]() |
|
|
FlashChat | Actuarial Discussion | Preliminary Exams | CAS/SOA Exams | Cyberchat | Around the World | Suggestions |
DW Simpson Global Actuarial & Analytics Recruitment |
View Poll Results: What is the best way to learn VBA? | |||
Book |
![]() ![]() ![]() ![]() |
110 | 35.48% |
Help |
![]() ![]() ![]() ![]() |
48 | 15.48% |
Internet |
![]() ![]() ![]() ![]() |
156 | 50.32% |
Macro Recorder |
![]() ![]() ![]() ![]() |
119 | 38.39% |
Multiple Choice Poll. Voters: 310. You may not vote on this poll |
![]() |
|
Thread Tools | Search this Thread | Display Modes |
#41
|
||||
|
||||
![]() Quote:
You are 100% correct in that the recorder is a problem when people use it in lieu of programming. The recorder is an awful programmer. Nonetheless, when people do this - they aren't interested in learning to program. They're just interested in having a program, and went to the cheapest source to get it. |
#42
|
||||
|
||||
![]() Quote:
Brad
__________________
Brad Gile, FSA, MAAA Affiliate Member of the CAS Dedicated Retired Actuary Spoiler: Spoiler: |
#43
|
||||
|
||||
![]() What type of jobs do you guys have in the industry where you are actually using this stuff?
Long ago, I created and used Excel macros for non-actuarial gig... but since I've been in the industry, I just haven't had the opportunity. The skill is gone. I enjoyed automating Excel with VBA though...
__________________
http://www.hillaryclinton.com/ |
#44
|
||||
|
||||
![]() Quote:
|
#45
|
||||
|
||||
![]() Quote:
For heavy duty stuff I use Mathcad. Brad
__________________
Brad Gile, FSA, MAAA Affiliate Member of the CAS Dedicated Retired Actuary Spoiler: Spoiler: |
#46
|
||||
|
||||
![]() The only stuff I've used VBA for have been non-project related at work: however, they've so far turned out very useful (turning a common 2 hour task into a 15 minute one). They won't be inherited, so they can be as sloppy and undocumented as I want as long as they do what I want
![]() |
#47
|
||||
|
||||
![]() Quote:
![]() Brad
__________________
Brad Gile, FSA, MAAA Affiliate Member of the CAS Dedicated Retired Actuary Spoiler: Spoiler: |
#48
|
||||
|
||||
![]() Quote:
![]() Before, it was data entry. Look in report, put number in form, look in report, put number in form. Now I can import the numbers directly into the form after the macro has run, which takes about a minute. The rest of the time is putting together the attachments ![]() |
#49
|
||||
|
||||
![]() Quote:
Creating non-excel functions. Mostly things like Poisson Inv and the functions found in Klugman. |
#50
|
||||
|
||||
![]() Quote:
Brad
__________________
Brad Gile, FSA, MAAA Affiliate Member of the CAS Dedicated Retired Actuary Spoiler: Spoiler: |
![]() |
Thread Tools | Search this Thread |
Display Modes | |
|
|