Macro programming in Excel
 

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

Macro programming in Excel
 

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

Macro programming in Excel
 

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!



"CarlosD_LongIsland" wrote:

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

Macro programming in Excel
 

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

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

Macro programming in Excel
 

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" wrote:

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

Macro programming in Excel
 

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

Macro programming in Excel
 

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.



"CarlosD_LongIsland" wrote:

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