Actuarial Outpost
 
Go Back   Actuarial Outpost > Actuarial Discussion Forum > Software & Technology
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

Reply
 
Thread Tools Display Modes
  #61  
Old 05-18-2007, 02:43 PM
Guest
Guest
 
Posts: n/a
Default

I just ordered an online ebook on VBA for Access.
- You also download files to work examples with from the site.


The 'programming' aspect is starting to actually make sense.

Automating a simple task: VBA recorder.
Learning to 'program' (with objects / methods / etc.): Book (with example files and walk throughs)
Reference: Help
Help on programming issues: Internet (MrExcel.com)

Last edited by Guest; 05-18-2007 at 02:47 PM..
Reply With Quote
  #62  
Old 05-24-2007, 10:47 PM
spencerhs5's Avatar
spencerhs5 spencerhs5 is offline
Member
 
Join Date: Jan 2007
Posts: 1,447
Default

I was wondering, on average, what VBA skills are needed in the profession. I basicly know C programming (although its been awhile and im verrry rusty). Is the VBA needed mostly for coding in excels VBA macro, is there much (if any) using the graphical code building function of VBA... and would there really be much of a reason to try and learn other things in Visual Studio i.e. SQL or C#?...
Reply With Quote
  #63  
Old 05-25-2007, 06:27 AM
Griffin 6's Avatar
Griffin 6 Griffin 6 is offline
Member
 
Join Date: Sep 2001
Location: You should be more ashamed of yourself than usual.
Favorite beer: 1934 World Heavyweight Champion Max Baer
Posts: 6,310
Default

Quote:
Originally Posted by atomic View Post
Is it because Excel is used by non-actuarial sectors to visually organize and manipulate data?
You will find that this is just as important as a program's ability to handle data. After all, the Actuarial Department is not a separate company.
__________________
e-Transport, Ltda. - International Freight Forwarders
__________________
Suvarna Chemical Industries - Manufacturers of Quality Pigment Pastes and Catalyst MEKP 50 %, Cobalt Accelerator and Cobalt Octoate for the Fiberglass Reinforced Plastic Industries
__________________
CLAAS of America, Inc. - Your Harvesting Specialist
__________________
Harbor Freight Tools - America's Favorite Tool Store
Reply With Quote
  #64  
Old 05-28-2007, 02:27 PM
concactu concactu is offline
Member
SOA
 
Join Date: Jul 2006
Location: NY
Studying for FAC
Posts: 174
Question

i want to learn VB this summer. all this terminology thats being tossed around this thread is foreign to me.
any advice on where i should start. I'm pretty good at excel and vaguely familar with access but i'd like to be fluent in VB programming.
Reply With Quote
  #65  
Old 05-28-2007, 05:37 PM
spencerhs5's Avatar
spencerhs5 spencerhs5 is offline
Member
 
Join Date: Jan 2007
Posts: 1,447
Default

im using a copy of excel 2007 vba for dummies, its pretty easy to understand and mildly entertaining although if you dont have 2007 you would wont the appropriate manual. he explicitly states that in the first chapter
Reply With Quote
  #66  
Old 05-28-2007, 06:14 PM
Brad Gile's Avatar
Brad Gile Brad Gile is offline
Member
CAS SOA AAA
 
Join Date: Sep 2001
Studying for whatever I feel like
College: Alumnus of Brown and UW-Madison
Posts: 11,341
Default

Quote:
Originally Posted by concactu View Post
i want to learn VB this summer. all this terminology thats being tossed around this thread is foreign to me.
any advice on where i should start. I'm pretty good at excel and vaguely familar with access but i'd like to be fluent in VB programming.
Start with post #1 in this thread (which is aptly titled, "Best way to learn VBA")!

Quote:
Originally Posted by Bama gambler
I'll rank my choices.

1. Good book. Any of the VBA books by Walkebach will do. This will help you write clean, readable code.

2. VBA Help files. Type what you want to do in help. They have some good examples.

3. Internet. Google it or post your question on a discussion board.

Avoid the macro recorder until you have honed your skills. It writes sloppy code and there is no macro recorder in Access.
These are all tools. The best way to learn any programming language is to practice writing code using good tools. Experiment and enjoy it.

Brad
__________________
Brad Gile, FSA, MAAA
Affiliate Member of the CAS
Dedicated Retired Actuary

Spoiler:
Obama sucks and we all know it-TDA


Spoiler:

That's been the funniest subplot of this whole thing, the people on the left attacking this bill for not being even more of a steaming pile. - erosewater
Reply With Quote
  #67  
Old 05-28-2007, 06:20 PM
Saskatchewary's Avatar
Saskatchewary Saskatchewary is offline
Member
 
Join Date: Apr 2006
Posts: 767
Default

Quote:
Originally Posted by spencerhs5 View Post
im using a copy of excel 2007 vba for dummies, its pretty easy to understand and mildly entertaining although if you dont have 2007 you would wont the appropriate manual. he explicitly states that in the first chapter
I have the same book (while using Excel 2003 ) and I find it very helpful. One downside is that I find I'm still spending a lot of time on the internets looking for help (mostly on syntax for functions not mentioned in the book). Maybe it's time I progress past the dummy stage of VBA literature. But I still second the recommendation. It's a great book even if you're not using Excel 2007.
Reply With Quote
  #68  
Old 05-28-2007, 06:30 PM
spencerhs5's Avatar
spencerhs5 spencerhs5 is offline
Member
 
Join Date: Jan 2007
Posts: 1,447
Default

yup its a great book, and i foresee most actuaries using 2007 very soon due to the major advancements in it. We now have the ability to use 1 million rows and 16 thousand columns! along with a bunch of other useful new features.
Reply With Quote
  #69  
Old 05-29-2007, 06:39 AM
Griffin 6's Avatar
Griffin 6 Griffin 6 is offline
Member
 
Join Date: Sep 2001
Location: You should be more ashamed of yourself than usual.
Favorite beer: 1934 World Heavyweight Champion Max Baer
Posts: 6,310
Default

Quote:
Originally Posted by spencerhs5 View Post
yup its a great book, and i foresee most actuaries using 2007 very soon due to the major advancements in it.
Is 2010 very soon?
__________________
e-Transport, Ltda. - International Freight Forwarders
__________________
Suvarna Chemical Industries - Manufacturers of Quality Pigment Pastes and Catalyst MEKP 50 %, Cobalt Accelerator and Cobalt Octoate for the Fiberglass Reinforced Plastic Industries
__________________
CLAAS of America, Inc. - Your Harvesting Specialist
__________________
Harbor Freight Tools - America's Favorite Tool Store
Reply With Quote
  #70  
Old 05-29-2007, 07:33 AM
JMO's Avatar
JMO JMO is offline
Carol Marler
Non-Actuary
 
Join Date: Sep 2001
Location: Back home again in Indiana
Studying for Nothing actuarial.
Posts: 36,310
Default

Quote:
Originally Posted by Griffin 6 View Post
Is 2010 very soon?
That depends. Do you mean Earth-soon or Mars-soon?
__________________
Carol Marler, "Just My Opinion"

Pluto is no longer a planet and I am no longer an actuary. Please take my opinions as non-actuarial.


My latest favorite quotes, updated Oct 13, 2017.

Spoiler:
I should keep these four permanently.
Quote:
Originally Posted by rekrap View Post
JMO is right
Quote:
Originally Posted by campbell View Post
I agree with JMO.
Quote:
Originally Posted by Westley View Post
And def agree w/ JMO.
Quote:
Originally Posted by MG View Post
This. And everything else JMO wrote.
MORE:
Quote:
Originally Posted by Bro View Post
I recommend you get perspective.
Quote:
Originally Posted by Enough Exams Already View Post
Dude, you can't fail a personality test. It just isn't that kind of test.
Quote:
Originally Posted by Locrian View Post
I'm disappointed I don't get to do both.
Quote:
Originally Posted by elleminopee View Post
For me, I take accusations of simplicity as more of a compliment than an insult. When the level of complexity in your model is more than you can validate, you are wasting your time.
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 09:47 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.33515 seconds with 10 queries