Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
what is the best book to learn macros indepth
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
what is the best book to learn macros indepth
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
what is the best book to learn macros indepth
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
what is the best book to learn macros indepth
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Best way to learn/use macros? | Excel Discussion (Misc queries) | |||
I want to learn Macros in excel, please let me know about it | New Users to Excel | |||
Is there a good book that would help me learn functions and formul | Excel Worksheet Functions | |||
Best Book for an Investment Banker to Learn Excel | New Users to Excel | |||
Best Book for an Investment Banker to Learn Excel | Excel Discussion (Misc queries) |