Welcome to the MacNN Forums.

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

You are here: MacNN Forums > Software - Troubleshooting and Discussion > Applications > Training: Excel Macros and Access

Training: Excel Macros and Access
Thread Tools
Mac Elite
Join Date: May 2000
Location: I've moved so many times; I forgot.
Status: Offline
Reply With Quote
Oct 30, 2006, 07:02 PM
 
Hi everyone,

I was wondering if I could get some advice as to courses to take.

I have extensive Excel experience, but have never played with writing macros at all. I've taken some basic programming courses in the past: Basic and Fortran. So I have some minor programming experience. But what I'd really like to do at this point is learn how to program Excel macros.

Also, I have zero Access experience and very little database experience. I used Filemaker years ago, but have had very little use for it since. I'm sure it's changed greatly in the interim, as have many databases. So I'm a total newb in this field.

I really wish my university had taught classes of this nature. Especially to those of us on finance and accounting tracks. It was greatly neglected though.

So does anyone have advice as to how I could go about learning this stuff. Investigate my local univ., any seminar experience, etc.?

Thanks!
Arty
"My friend, there are two kinds of people in this world:
those with loaded guns, and those who dig. You dig."

-Clint in "The Good, the Bad and the Ugly"
     
Dedicated MacNNer
Join Date: Mar 2001
Location: Indianapolis, IN USA
Status: Offline
Reply With Quote
Oct 31, 2006, 07:05 AM
 
There's a book by a guy named John Walkenbach about Excel Macro programming that's really good. Also, take a llok at Ask Mr. Excel - Tips and Solutions for Excel Their forum is great.

You know the next version of Excel for Mac won't have Visual Basic, don't you? But if you're talking about Access, you must be doing this on Windows.
     
   
Thread Tools
Forum Links
Forum 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
Trackbacks are On
Pingbacks are On
Refbacks are On
Top
Privacy Policy
All times are GMT -5. The time now is 08:14 AM.
All contents of these forums © 1995-2011 MacNN. All rights reserved.
Branding + Design: www.gesamtbild.com
vBulletin v.3.8.7 © 2000-2011, Jelsoft Enterprises Ltd., Content Relevant URLs by vBSEO 3.3.2