Excel 2003 Power Programming with VBA
and over one million other books are available for Amazon Kindle .
Learn more
| |||||||||||||||
 Trade In this Item for up to £2.40
Trade in Excel 2003 Power Programming with VBA for an Amazon.co.uk gift card of up to £2.40, which you can then spend on millions of items across the site. Plus, get an extra £5 when you trade in books worth £10 or more until June 30, 2012. Trade-in values may vary (terms apply). Find more products eligible for trade-in.
|
Frequently Bought Together
Product details
|
More About the Author
Product Description
Product Description
"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.
––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.
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
—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.
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
Tags Customers Associate with This Product(What's this?)Click on a tag to find related items, discussions, and people.
|
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
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
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
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?
Were these reviews helpful?
Let us know
Most Recent Customer Reviews
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 13 months ago by Dr. J. H. Campbell
EXCEL-LENT Purchase!
I cannot rate this book highly enough. John Walkenbach has justifiably earned the epithet "Mr Excel". Read more
Published 15 months ago by Nigel Foster
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
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
Look for similar items by subject
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.
|
