Product Description

Get the most out of Excel, Microsoft's powerful spreadsheet application. With John Walkenbach, the leading Excel expert better known as "Mr. Spreadsheet", discover better ways to analyze data and find solutions using Microsoft Excel 2002.

This book is an excellent resource for getting up to speed using streamlined spreadsheet creation tools, enhanced analysis tools and powerful Web integration. Transform Excel into an application suited to the whole organization so workgroups can work more effectively. Discover how developers can integrate information seamlessly, whether proposal text, financial figures or research data. Whether you are an expert or a novice, Excel 2002 Power Programming with VBA will help you work more efficiently, turning your data into answers you can count on.

Bonus: The book contains a coupon for the Professional Power Utility Pak.

Product Details

• Amazon Sales Rank: #246353 in Books
• Published on: 2001-07-15
• Number of items: 1
• Binding: Paperback
• 984 pages

From the Back Cover
Excel 2002 Power Programming with VBA Develop Powerful, User-Oriented Excel 2002 Applications With this unique guide, renowned spreadsheet authority John Walkenbach invites you to harness the full potential of Excel-and join the elite group of users and developers who truly understand what the product is capable of. Offering plenty of detailed, well-thought-out examples, he walks you through the basics of Excel application development and VBA programming-and then gives you a lucid, wide-ranging seminar on advanced programming techniques and application development issues. It's all you need to create user-oriented custom applications that leverage the power of Excel 2002. Your Road Map to Excel Application Development
* Take Excel to the next level with formula tricks and techniques
* Work with VBA sub procedures and function procedures
* Create stellar UserForms as well as custom dialog box alternatives
* Develop applications that maximize the power of PivotTables and charts
* Incorporate event-handling and interactions with other applications
* Build user-friendly toolbars, menus, and help systems
* Manipulate files and Visual Basic components and understand class modules
* Get advice on compatibility issues and answers to frequently asked Excel programming questions
Bonus CD-ROM Includes
* A trial version of the author's award-winning Power Utility Pak 2000
* A demo of the author's Sound-Proof 2000
* Over 175 example Excel workbooks from the book
System Requirements: Pentium PC with Windows 98 or greater; 32 MB RAM; Microsoft Excel 2002. See About the CD appendix for details and complete system requirements. www.mandtbooks.com

About the Author
John Walkenbach is a principal of JWalk and Associates, Inc., a consulting firm that specializes in spreadsheet application development, and is the author of more than two dozen books, including, most recently, Excel 2002 Bible and Excel 2002 Formulas. He maintains "The Spreadsheet Page," a popular Web resource at www.j-walk.com/ss.

Customer Reviews

This book is worth every penny
This book is oriented for those with basic knowledges of Excel and some general understanding of Visual Basic (Visual Basic 6 not Visual Basic .NET). However, the examples are simple, sequential and conductive for constructing basic applications even if you have never used Visual Basic before.

Let the Author, Mr. John Walkenback, take you through the first 7 Chapters, type in the examples as you go, and you will rip the benefits.

No real life examples
This book sucks! Its just a little better than the help file included in with Excel. All he does is put it in a diffrent order. I was expecting small excercises where I could put my new skills all together, but there is none. So you read the whole book, remember as much as you can, and go off and try to mix and match hundreds of commands... buy another one.

Excelent manual for intermediate and higher programmers!
This is a great manual for those who, at a minimum, have a limited knowledge of Visual Basic and a limited working knowledge of Excel. If you don't consider yourself an expert then this is the book for you!

I've taught myself multiple computer languages (English is my natural language but that doesn't really matter now, does it?) and am very familiar with Excel -- but not so much on the programming side of things. As far as being a VB programmer, well, about two or three years ago I taught myself VB 5.0 and then never ended up needing to use it. The first time I used this book was to help me with a VB module in a customers Excel workbook. There was even an example in this book about using the Windows API to get the window to search for a directory which I was able to easily incorporate into the code. I then started reading through the chapters and just kept on learning more and more! When working on a project I can easily find a relevant chapter/section that pertains to what I'm doing or need and solve my problem!

He clearly explains his code and if the example is a code snipet. The included CD contains his examples and other files which I find very helpful, especially when I don't want to type in everything myself :-)

If you even *think* this may be a candidate for your library then stop thinking and just get it!