Macro training

[Guest]

I'm pretty fluent with most of Excel but haven't coded macros. I find the
tutorial that comes with Excel to be unhelpful. Could anyone recommend a
specific course in Excel macros?

 

[Tyro]

There are many good books on Visual Basic for Applications. Among them:
Microsoft Office Excel 2003 Programming Inside Out, Excel 2003 Power
Programming with VBA and Excel 2003 VBA. These books may also be available
for Excel 2007. Barnes & Noble usually carries these in the U.S.

 

[Guest]

Go to Amazon.com And Enter: Excel VBA in the search for box;
Prepare to see plenty - New and Used !!

 

[David McRitchie]

The very first thing you must do with a macro is install it;
If you haven't already installed a macro from posted code, you\
might want to look at http://www.mvps.org/dmcritchie/excel/getstarted.htm

There are lots of online tutorials to help get you started with coding
http://www.mvps.org/dmcritchie/excel/excel.htm#vbatutorials

 

[iliace]

Besides the books already mentioned, I would recommend looking into
some material on VB6, especially if you don't have much programming
experience. While much of the material will not be directly relevant
(and some out of date), a book specific to Visual Basic will go into
great detail on VB basics, classes, interfaces, events, ADO, COM, and
other items that you'd need if you are both serious and wish to be
efficient. Majority of VBA-specific material either skim these parts,
don't start at the beginning, or don't go far enough.

Coming from a curly-brackets programming background (C++ and Java), I
use Programming Microsoft Visual Basic 6.0 by Francesco Balena for
reference all the time, when developing Excel- and Access-based
solutions with VBA.