"Today, no accomplished Excel programmer can afford to be without John′s book. The value of Excel 2003 Power Programming with VBA is double most other books–simultaneously the premier reference and best learning tool for Excel VBA." ––Loren Abdulezer, Author of Excel Best Practices for Business Everything you need to know about: ∗ Creating stellar UserForms and custom dialog box alternatives ∗ Working with VBA subprocedures and function procedures ∗ Incorporating event–handling and interactions with other applications ∗ Building user–friendly toolbars, menus, and help systems ∗ Manipulating files and Visual Basic components ∗ Understanding class modules ∗ Managing compatibility issues Feel the power of VBA and Excel No one can uncover Excel′s hidden capabilities like "Mr. Spreadsheet" himself. John Walkenbach begins this power user′s guide with a conceptual overview, an analysis of Excel application development, and a complete introduction to VBA. Then, he shows you how to customize Excel UserForms, develop new utilities, use VBA with charts and pivot tables, create event–handling applications, and much more. If you′re fairly new to Excel programming, here′s the foundation you need. If you′re already a VBA veteran, you can start mining a rich lode of programming ideas right away. CD–ROM Includes ∗ Trial version of the author′s award–winning Power Utility Pak ∗ Over one hundred example Excel workbooks from the book System Requirements: PC running Windows 2000 SP3 or later, or Windows XP(TM) or later. Microsoft Excel 2003. See the "What′s on the CD" Appendix for details and complete system requirements.
Excel 2003 Power Programming with VBA
and over 1.5 million other books are available for Amazon Kindle . Learn more
| |||||||||||||||
 Trade In this Item for up to £9.20
Trade in Excel 2003 Power Programming with VBA for an Amazon.co.uk gift card of up to £9.20, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Learn more
|
Book Description
Frequently Bought Together
Product details
Would you like to update product info or give feedback on images?
|
More About the Author
Discover books, learn about writers, and more.
Product Description
From the Back Cover
"Today, no accomplished Excel programmer can afford to be without John’s book. The value of Excel 2003 Power Programming with VBA is double most other books–simultaneously the premier reference and best learning tool for Excel VBA." —Loren Abdulezer, Author of Excel Best Practices for Business Everything you need to know about: Creating stellar UserForms and custom dialog box alternatives Working with VBA subprocedures and function procedures Incorporating event–handling and interactions with other applications Building user–friendly toolbars, menus, and help systems Manipulating files and Visual Basic® components Understanding class modules Managing compatibility issues Feel the power of VBA and Excel No one can uncover Excel’s hidden capabilities like "Mr. Spreadsheet" himself. John Walkenbach begins this power user’s guide with a conceptual overview, an analysis of Excel application development, and a complete introduction to VBA. Then, he shows you how to customize Excel UserForms, develop new utilities, use VBA with charts and pivot tables, create event–handling applications, and much more. If you’re fairly new to Excel programming, here’s the foundation you need. If you’re already a VBA veteran, you can start mining a rich lode of programming ideas right away. CD–ROM Includes Trial version of the author’s award–winning Power Utility Pak Over one hundred example Excel workbooks from the book System Requirements: PC running Windows® 2000 SP3 or later, or Windows XP™ or later. Microsoft Excel 2003. See the "What’s on the CD" Appendix for details and complete system requirements.
About the Author
John Walkenbach , principal of JWalk and Associates Inc., is a leading authority on spreadsheet software and creator of the award–winning Power Utility Pak. He has written more than 30 spreadsheet books and more than 300 articles and reviews for publications including PC World , InfoWorld , and Windows , and maintains the popular Spreadsheet Page at www.j–walk.com/ss.
Inside This Book
(Learn More)
First Sentence
To fully appreciate the application development features available in Excel 2003, it's important to understand where this product came from and how it fits into the overall scheme of things. Read the first page
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
To fully appreciate the application development features available in Excel 2003, it's important to understand where this product came from and how it fits into the overall scheme of things. Read the first page
Explore More
Concordance
Browse Sample PagesConcordance
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
What Other Items Do Customers Buy After Viewing This Item?
Customer Reviews
Most Helpful Customer Reviews
20 of 20 people found the following review helpful
By Jon Simpson
Format:Paperback
I am a pretty experienced Access developer but recently needed to use excel for many of the reports and forms. The info on the excel object model, charts and pivot tables was the main reason I bought the book and this was all well laid out and easy to follow.
What really impressed me was the info on interacting with other Aps and the API / Registry; more comprehensive than many other MS Office development book I have seen.
On the negative side the info on ADO and Class modules was too sketchy for beginners and too basic for those with Access experience to be useful and would be better ignored
5 of 5 people found the following review helpful
By Dr. M
Format:Paperback|Amazon Verified Purchase
I am a self-taught VBA programmer with moderate to good understanding of VBA and was looking for a book to take me to the next skill level. Most books I have bought so far (about 5!) have been relatively hopeless, being either too basic or far too technical.
However, John Walkenbach's book is in a league of its own. It starts off simply enough but rapidly and effortlessly works up to more complex ideas and scripts. He provides you with lots of handy tips and tricks and ensures you have a good grounding in each topic before advancing. His language is simple and easy to read with lots of working examples and a wide array of topics.
This book is really excellent and I can HIGHLY recommend it for a user of almost any skill level. I also highly recommend his book on Excel 2003 Formulas. In combination these two books will help you comfortably conquer Excel.
However, John Walkenbach's book is in a league of its own. It starts off simply enough but rapidly and effortlessly works up to more complex ideas and scripts. He provides you with lots of handy tips and tricks and ensures you have a good grounding in each topic before advancing. His language is simple and easy to read with lots of working examples and a wide array of topics.
This book is really excellent and I can HIGHLY recommend it for a user of almost any skill level. I also highly recommend his book on Excel 2003 Formulas. In combination these two books will help you comfortably conquer Excel.
1 of 1 people found the following review helpful
By M. Donovan
Format:Paperback
Having read VBA for dummies this book seemed like the next logical step.
I am about half way through the book and have the following comments;
The is a lot of sections at the start of the book which i feel are fillers, some of the text seems to be almost cut and pasted from VBA for dummies, as a power programing book i didnt expect it to cover some very basic topics in such detail. That aside it was a nice refresher but i did find myself skimming over alot.
Once the book gets going onto more intermediate topics it gets much better and some of the pre writen user functions are good to be implimented into code i write every day, some required applying of the principle to make them useful(which is no bad thing as it stimulates code practice).
I have found the to be some typos and errors in the book which i have noticed on sections of code that i already fully understand, i hope that the are not to many of these on the code i dont understand. On the whole most the errors are related to bad english, missing text (missing figure lables on some examples) and words words repeated!
I would totaly agree with most over reviews of this book in the fact it is not a reference book, but it is a good book to read through as a set of lessons.
I would buy books from this author again but would suplement them with a good reference book on the side.
I am about half way through the book and have the following comments;
The is a lot of sections at the start of the book which i feel are fillers, some of the text seems to be almost cut and pasted from VBA for dummies, as a power programing book i didnt expect it to cover some very basic topics in such detail. That aside it was a nice refresher but i did find myself skimming over alot.
Once the book gets going onto more intermediate topics it gets much better and some of the pre writen user functions are good to be implimented into code i write every day, some required applying of the principle to make them useful(which is no bad thing as it stimulates code practice).
I have found the to be some typos and errors in the book which i have noticed on sections of code that i already fully understand, i hope that the are not to many of these on the code i dont understand. On the whole most the errors are related to bad english, missing text (missing figure lables on some examples) and words words repeated!
I would totaly agree with most over reviews of this book in the fact it is not a reference book, but it is a good book to read through as a set of lessons.
I would buy books from this author again but would suplement them with a good reference book on the side.
Would you like to see more reviews about this item?
›
Go to Amazon.com to see all 51 reviews
4.1 out of 5 stars
Were these reviews helpful?
Let us know
Most Recent Customer Reviews
3.0 out of 5 stars
Good advice but the examples are not easy to read on kindle
I purchased this book so that I could learn about VBA. It cdertainly had a lot of content and was very informative. Read more
Published 7 months ago by da
5.0 out of 5 stars
Couldn't be any better
I bought this book while working on a VBA project that was just a bit more complex than my current programming abilities, and I found it immediately useful. Read more
Published on 1 May 2011 by Dr. J. H. Campbell
5.0 out of 5 stars
EXCEL-LENT Purchase!
I cannot rate this book highly enough. John Walkenbach has justifiably earned the epithet "Mr Excel". Read more
Published on 9 Feb 2011 by Nigel Foster
3.0 out of 5 stars
Indexes
I like this book it have a lot of exampels, but what they totaly forgoten is to build a good Index on where to find diffrent subjects in the book. Read more
Published on 19 Mar 2004 by Benny Jensen
Customer Discussions
|
This product's forum
Search Customer Discussions
|
Related forums
|
Listmania!
|
|
Look for similar items by category
- Books > Computing & Internet > Digital Lifestyle > Online Shopping > Amazon
- Books > Computing & Internet > Microsoft Windows > Applications > Excel > Excel 2003
- Books > Computing & Internet > Microsoft Windows > Applications > Excel > Programming
- Books > Computing & Internet > Software & Graphics > Business & Home Office > Spreadsheets
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
|
