E
excel macros
pls help i want to learn excel macros fast to get the job .pls help me
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
O
ozgrid.com
Our training cost less than most books
http://www.ozgrid.com/TrainingLessons/excel-VBA-training-download1.htm
http://www.ozgrid.com/TrainingLessons/excel-VBA-training-download1.htm
D
Dave Peterson
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.
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.
J
James Silverton
Dave wrote on Mon, 19 Apr 2010 06:28:50 -0500:
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
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.
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
D
Dave Peterson
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>.
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>.