Macro programming in Excel

[Guest]

I'd like to get a recommended source of info (books,CD's, etc.) where I can
learn how to program macros in Excel. I know the embedded recording method,
but I need to program spcial activities i.e. in a given table, move the
cursor until a certain value is found and if so delete the row. Basically, I
need to know the language syntax, the method of inserting and saving the
macro, its availability for other spreadsheets, etc.
Thanks

 

[Bob Phillips]

You have specific needs rather than just a learning situation, so I would
suggest that you record basic macros, try and amend, and post detailed
questions (code and data as well) when you have a problem to this NG. You
will soon improve, especially if you so some research of your own (using
Help and the object browser).

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

A personal recommendation is John Walkenbach's "Excel 2002 Power Programming
with VBA" which comes with a CD full of practical examples.

Combine this (or any other recommended book) with the encyclopaedic
knowledge of the experts who support this NG - providing endless examples of
both good code and good practice - and you can't go wrong!

 

[Guest]

Thanks, Bob. You are correct in your assessment. However, I'd still like to
read a book that might contain the subject in a structured manner. I'll
explain: in the 1-2-3 days, I had a great command of the Lotus macro
language, from the syntax chapter in Lotus handbooks. Is there a similar
book on Excel programming?

 

[Bob Phillips]

Well John Walkenbach does Excel VBA Programming For Dummies ISBN:
0-7645-7412-4 which is probably the best starter book. Once mastered, look
at John Green's VBA 2002 Programmers Reference Manual (avoid the 2003
version).

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

My thanks to you Bob and Toppers... I have already placed my order with
Amazon and will get started from there (I am a good learner from books, thus
my insistence)
Again, thank you and I am sure I'll be back here with specifics...
CarlosD

 

[Bob Phillips]

My thanks to you Bob and Toppers... I have already placed my order with
Amazon and will get started from there (I am a good learner from books, thus
my insistence)

You are in an elite group then, most people I know (me included) are useless


Seriously though, all mentioned are good books that will get you going
nicely.

 

[Elliot]

Try the forthcoming "Excel Basics to Blackbelt" www.excel-blackbelt.com
Lot's of gems - catered to Excel 2007 but useful for all prior versions as
well.