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
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" <carlosd@discussions.microsoft.com> wrote in message
news:45D291EC-6EFE-4E5C-824C-B8558D659D71@microsoft.com...
> 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
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
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" <carlosd@discussions.microsoft.com> wrote in message
> news:45D291EC-6EFE-4E5C-824C-B8558D659D71@microsoft.com...
> > 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
>
>
>
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" <carlosd@discussions.microsoft.com> wrote in message
news:E636A64D-EFBD-4809-9719-FEB96E41F1A5@microsoft.com...
> 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" <carlosd@discussions.microsoft.com> wrote in
message
> > news:45D291EC-6EFE-4E5C-824C-B8558D659D71@microsoft.com...
> > > 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
> >
> >
> >
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" <carlosd@discussions.microsoft.com> wrote in message
> news:E636A64D-EFBD-4809-9719-FEB96E41F1A5@microsoft.com...
> > 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" <carlosd@discussions.microsoft.com> wrote in
> message
> > > news:45D291EC-6EFE-4E5C-824C-B8558D659D71@microsoft.com...
> > > > 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
> > >
> > >
> > >
>
>
>
"CarlosD_LongIsland" <carlosd@discussions.microsoft.com> wrote in message
news:ADDD7710-3662-45C9-9867-4D34EE41624A@microsoft.com...
> 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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks