- Paperback: 912 pages
- Publisher: *M&T Press; 1 edition (May 21, 1999)
- Language: English
- ISBN-10: 0764532634
- ISBN-13: 978-0764532634
- Product Dimensions: 7.4 x 2 x 9.1 inches
- Shipping Weight: 3 pounds (View shipping rates and policies)
- Average Customer Review: 50 customer reviews
- Amazon Best Sellers Rank: #2,843,649 in Books (See Top 100 in Books)
Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
Microsoft Excel 2000 Power Programming with VBA 1st Edition
Use the Amazon App to scan ISBNs and compare prices.
Fulfillment by Amazon (FBA) is a service we offer sellers that lets them store their products in Amazon's fulfillment centers, and we directly pack, ship, and provide customer service for these products. Something we hope you'll especially enjoy: FBA items qualify for FREE Shipping and Amazon Prime.
If you're a seller, Fulfillment by Amazon can help you increase your sales. We invite you to learn more about Fulfillment by Amazon .
See the Best Books of 2018 So Far
Looking for something great to read? Browse our editors' picks for the best books of the year so far in fiction, nonfiction, mysteries, children's books, and much more.
If you've mastered Excel and need to develop customized applications, Microsoft Excel 2000 Power Programming with VBA should have a place by your side. Written by noted Excel expert and PC World columnist John Walkenbach, it will thrust you deep into the inner workings of Excel and Visual Basic for Applications (VBA) to get you writing code immediately.
Somewhat text-heavy (as programming books tend to be), it still contains a number of good illustrations and screenshots to effectively teach you. The first three sections cover the fundamentals of Excel and VBA; the next three deal with programming and development topics such as user forms, pivot tables, and event handling; the final section covers miscellaneous issues like compatibility, file manipulation, and class modules.
The five appendices are useful for referencing Excel and VBA information, and the accompanying CD-ROM contains all the code and files you'll need to work through the book, not to mention the shareware version of Walkenbach's Power Utility Pack. (The full version is available through a free offer.) Nobody ever said programming was easy, but with Microsoft Excel 2000 Power Programming with VBA it's a lot simpler. --Rob Lightner
From the Back Cover
Microsoft® Excel 2000 Power Programming with VBA With the latest version of Visual Basic for Applications and the new Office Component Object Model, Excel 2000 now provides an amazing platform for the development of custom spreadsheets and turnkey applications for a wide range of business needs. With the expert guidance of John Walkenbach, a leading Excel expert better known as "Mr. Spreadsheet," you'll quickly learn how to harness the full programming power of Excel 2000 from UserForms to class modules. Take Your Spreadsheets to a Whole New Level
- Master the overall design-development-deployment process for Excel applications
- Take complete control of the Visual Basic Editor environment
- Learn how to work with VBA objects, subprocedures, and functions
- Explore basic to advanced techniques for building intuitive UserForms
- Use VBA to develop robust Excel utilities from the ground up
- Find out how to program Excel to respond to a wide variety of events
- Discover how to automate charts and pivot tables in your applications
- Create custom toolbars, menus, and help files
- Figure out how to manipulate text files and Visual Basic Project components at design time
- Understand what class modules are and how to use them
Top customer reviews
There was a problem filtering reviews right now. Please try again later.
Its organization, layout, and even simply its appearance make it a pleasure to use and a massively useful companion for developers.
Another thing I like about it is that, unlike most books - which are either comic-book level manuals (i.e., glorified pamphlets) for non-technical people, or super-technical tomes of gobbledigook that won't help you do anything until you've mastered at least the first 800 pages - you can actually use this book for any level of expertise you'll need, anywhere from "I just want to get a user form in there for filling in a template" to "I'm gonna knock their socks off by integrating this into their business objects layer with logic-driven pivot table creators"
The explanations are coherent, the examples are clear and well-illustrated, and the companion CD has a lot of pre-written code you can plagia... um, learn from in developing your own solutions.
If you're already a professional developer, then I seriously doubt you'll like the book because it devotes a lot of space to the fundamentals of VBA and programming.
The author recommends using comments in code, but many examples lack sufficient comments which would greatly aid the reader. The author also recommends using OPTION EXPLICIT (which requires the user to declare variable types), but variables are undefined in many examples which makes the examples more difficult to understand. The author does not recommend (and does not use) prefixes on variable names to identify types. This variable naming convention, which is widely used, would also make his examples more understandable.
In my opinion, several chapters appear out of place. The chapter on reading/writing text files, which appears at the end of the book, should be covered much earlier. The chapter on class modules is the second last chapter even though the author uses class modules in the examples in at least 4 previous chapters. The author states that "complete coverage" of class modules is beyond the scope of the book, but fails to explain some concepts used in the class modules in the prior chapters.
The Power Utility Pak included on the CD-ROM is a demo version for Excel 97 with many features non-operational. The book does includes a coupon for a FREE copy of Power Pak 2000 ... but it will cost you S&H.
Although the book has relatively few errors, the errors I have detected and submitted to the author have apparently "fallen on deaf ears" and have not been published on the author's website for the benefit of other readers.
I think the author should have spent more time making the content of the book match the title of the book. The majority of the book deals with Excel 97 material. Very little information in this book is specific to Excel 2000. In my opinion the book should be rated for a reader level of "Beginner to Intermediate" rather than "Intermediate to Advanced". At least 100 pages of "boiler plate stuff" should be eliminated and replaced with "advanced stuff".
NEVERTHELESS, despite all my criticisms ... Good Excel books at the intermediate/advanced level are hard to find. Readers can obtain valuable information by reading the text and carefully following the author's examples in both the book and on the CD-ROM.
It gets you started.
Most recent customer reviews
It was exactly what I was looking for and it is helping me a lot to make quite complicated macro.