View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Macro programming in Excel

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)


"CarlosD_LongIsland" wrote in message
...
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" wrote:

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)


"CarlosD_LongIsland" wrote in

message
...
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
--
CarlosD_LongIsland