Actuarial Outpost
 
Go Back   Actuarial Outpost > Actuarial Discussion Forum > Software & Technology
FlashChat Actuarial Discussion Preliminary Exams CAS/SOA Exams Cyberchat Around the World Suggestions


Reply
 
Thread Tools Display Modes
  #1  
Old 05-07-2017, 12:59 PM
ronaldy27's Avatar
ronaldy27 ronaldy27 is offline
Member
SOA
 
Join Date: Jan 2012
Studying for MLC
Posts: 1,266
Default VBA work

Can some of the experienced actuaries talk about some work you have done using VBA?
__________________
Spoiler - for size:



Reply With Quote
  #2  
Old 05-07-2017, 01:52 PM
Abelian Grape's Avatar
Abelian Grape Abelian Grape is offline
Meme-ber                         Meme-ber
Non-Actuary
 
Join Date: Jul 2014
Location: Commuter
Studying for Viticulture dissertation
College: Grape and Wine Institute
Favorite beer: Wine
Posts: 33,547
Default

Yes
__________________
Reply With Quote
  #3  
Old 05-07-2017, 02:24 PM
Rick_G's Avatar
Rick_G Rick_G is offline
Member
 
Join Date: May 2005
Location: Just south of the Big Chicken
Posts: 2,028
Default

I've used VBA for all kinds of things with Microsoft Office. If I have to do something on a routine basis, I will find a way to automate it using VBA:
  • Mail merge using a form in Access to create Word documents
  • Update web site using FrontPage
  • Ridiculously complicated Word mail merge with multiple document sources
  • Update multiple linked Excel files using varying Excel sheets as sources
  • Update FedEx web pages in Internet Explorer using a form in Access
__________________
Rick Groszkiewicz


Now offering online seminars, live seminars, and everything else under the sun for actuarial exams.
EA-2F and EA-2L and EA-1
Reply With Quote
  #4  
Old 05-07-2017, 03:32 PM
ronaldy27's Avatar
ronaldy27 ronaldy27 is offline
Member
SOA
 
Join Date: Jan 2012
Studying for MLC
Posts: 1,266
Default

Quote:
Originally Posted by Abelian Grape View Post
Yes
Come on man. Give me something
Man, I missed AO and you
__________________
Spoiler - for size:



Reply With Quote
  #5  
Old 05-07-2017, 10:22 PM
Tacoactuary's Avatar
Tacoactuary Tacoactuary is offline
Member
CAS Non-Actuary
 
Join Date: Nov 2014
Location: Des Moines, IA
College: Vanderbilt, UIUC
Favorite beer: Yazoo Sue
Posts: 483
Default

By far #1 is automating report generation and customization, followed by pdf production because management doesn't want to look at excel files. Besides that, lots of miscellaneous algorithms that don't exist in vanilla excel which I find helpful.
__________________
ACAS 7 8 9
Reply With Quote
  #6  
Old 05-07-2017, 11:10 PM
erosewater's Avatar
erosewater erosewater is offline
Member
 
Join Date: Aug 2003
Location: my mom's basement
Studying for your mom
Favorite beer: Schlitz
Posts: 65,300
Default

Quote:
Originally Posted by Rick_G View Post
[*]Update web site using FrontPage
lol
Reply With Quote
  #7  
Old 05-08-2017, 08:43 AM
Sredni Vashtar's Avatar
Sredni Vashtar Sredni Vashtar is offline
Member
 
Join Date: Mar 2010
Favorite beer: pilseners
Posts: 3,546
Canada

Quote:
Originally Posted by ronaldy27 View Post
Can some of the experienced actuaries talk about some work you have done using VBA?
1) most valuable VBA tool:

For i = 1 to 10,000
Put some number into a cell.
Calculate.
Copy some numbers from a range to some other range.
Next i
__________________
Sredni Vashtar went forth,
His thoughts were red thoughts and his teeth were white.
His enemies called for peace, but he brought them death.
Sredni Vashtar the Beautiful.

Last edited by Sredni Vashtar; 05-08-2017 at 08:46 AM..
Reply With Quote
  #8  
Old 05-08-2017, 10:29 AM
Rick_G's Avatar
Rick_G Rick_G is offline
Member
 
Join Date: May 2005
Location: Just south of the Big Chicken
Posts: 2,028
Default

Quote:
Originally Posted by erosewater View Post
Quote:
Originally Posted by Rick_G View Post
  • Update web site using FrontPage
lol
Yeah, some day I will finish converting my web site from FrontPage to WordPress.
__________________
Rick Groszkiewicz


Now offering online seminars, live seminars, and everything else under the sun for actuarial exams.
EA-2F and EA-2L and EA-1
Reply With Quote
  #9  
Old 05-08-2017, 11:31 AM
Maphisto's Sidekick's Avatar
Maphisto's Sidekick Maphisto's Sidekick is offline
Member
CAS AAA
 
Join Date: Nov 2001
Location: South Park Genetics Lab
College: Ardnox
Favorite beer: The kind with alcohol
Posts: 1,890
Default

Basically any function I need which isn't covered in the version of Excel corporate decrees that I use, I use VBA to create.

Any mindless, repetitive task that I encounter that will consume more time than it would take to write a macro for, I use VBA for.

In Excel, if working with a large spreadsheet, I'll sometimes use VBA macros to copy/paste-formulas/recalculate-active-cell/copy/paste-values, to keep file size down and recalculation time reduced.

And almost no one ever thinks about VBA in Outlook. If you're using an older version of Outlook that doesn't warn about possibly forgetting to attach an attachment, there's a macro for that. And, you can automate creating reminder tasks based on emails sent/received...
Reply With Quote
  #10  
Old 05-08-2017, 11:39 AM
ronaldy27's Avatar
ronaldy27 ronaldy27 is offline
Member
SOA
 
Join Date: Jan 2012
Studying for MLC
Posts: 1,266
Default

Quote:
Originally Posted by Maphisto's Sidekick View Post
Basically any function I need which isn't covered in the version of Excel corporate decrees that I use, I use VBA to create.

Any mindless, repetitive task that I encounter that will consume more time than it would take to write a macro for, I use VBA for.

In Excel, if working with a large spreadsheet, I'll sometimes use VBA macros to copy/paste-formulas/recalculate-active-cell/copy/paste-values, to keep file size down and recalculation time reduced.

And almost no one ever thinks about VBA in Outlook. If you're using an older version of Outlook that doesn't warn about possibly forgetting to attach an attachment, there's a macro for that. And, you can automate creating reminder tasks based on emails sent/received...
That sounds really interesting. I started learning VBA by watching videos on youtube. Do you have any book/website recommendation for learning VBA? I know VBA is used very broadly but I'm trying to find a source that can teach me functions used by actuaries.

Thank you in advance.
__________________
Spoiler - for size:



Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


All times are GMT -4. The time now is 07:18 AM.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
*PLEASE NOTE: Posts are not checked for accuracy, and do not
represent the views of the Actuarial Outpost or its sponsors.
Page generated in 0.19845 seconds with 9 queries