what is the best book to learn macros indepth

pls help i want to learn excel macros fast to get the job .pls help me

Our training cost less than most books
http://www.ozgrid.com/TrainingLesson...-download1.htm



--
Regards
Dave Hawley
www.ozgrid.com
"excel macros" excel macros @discussions.microsoft.com wrote in message
...
pls help i want to learn excel macros fast to get the job .pls help me

Debra Dalgleish has a list of books at her site:
http://www.contextures.com/xlbooks.html

John Walkenbach's books are very good to start.

Professional Excel Development by Stephen Bullen, Rob Bovey, John Green is
pretty advanced, but very good.

See if you can find them in your local bookstore/internet site and you can
choose what one(s) you like best.

excel macros wrote:

pls help i want to learn excel macros fast to get the job .pls help me

--

Dave Peterson

Dave wrote on Mon, 19 Apr 2010 06:28:50 -0500:

John Walkenbach's books are very good to start.

Professional Excel Development by Stephen Bullen, Rob Bovey,
John Green is pretty advanced, but very good.

See if you can find them in your local bookstore/internet site
and you can choose what one(s) you like best.

excel macros wrote:

pls help i want to learn excel macros fast to get the job
.pls help me

Not to knock books on VBA but, for myself, I usually start by recording
the macro for what I want and then modifying it with VBA. I understand
that this is not an uncommon practice even with professionals. There are
things you can't readily record, for example loops, but they are easy
enough to include by editing and it is good to have a knowledge of the
various commands of Excel VBA. I find myself referring to Walkenbach
quite a lot.

--

James Silverton
Potomac, Maryland

Email, with obvious alterations: not.jim.silverton.at.verizon.not

I know that I learned the most by lurking in the newsgroups. There were names
that I know I could trust -- both in coding style and quality of code.

I'd save the posts that were most interesting.

Later, I'd try coming up with the code myself without posting any code. Then
I'd look to see if my code was close to those trusted posters.

And later, I got comfortable enough to post my efforts. And when that code
wasn't good, there are lots of people who will offer suggestions vbg.

James Silverton wrote:

Dave wrote on Mon, 19 Apr 2010 06:28:50 -0500:

John Walkenbach's books are very good to start.

Professional Excel Development by Stephen Bullen, Rob Bovey,
John Green is pretty advanced, but very good.

See if you can find them in your local bookstore/internet site
and you can choose what one(s) you like best.

excel macros wrote:

pls help i want to learn excel macros fast to get the job
.pls help me

Not to knock books on VBA but, for myself, I usually start by recording
the macro for what I want and then modifying it with VBA. I understand
that this is not an uncommon practice even with professionals. There are
things you can't readily record, for example loops, but they are easy
enough to include by editing and it is good to have a knowledge of the
various commands of Excel VBA. I find myself referring to Walkenbach
quite a lot.

--

James Silverton
Potomac, Maryland

Email, with obvious alterations: not.jim.silverton.at.verizon.not

--

Dave Peterson