Star Wars Sale
 
 

Special Offers see all

Enter to WIN!

Weekly drawing for $100 credit. Subscribe to PowellsBooks.news for a chance to win.
Privacy Policy

More at Powell's


Recently Viewed clear list


Original Essays | June 20, 2014

Lauren Owen: IMG The Other Vampire



It's a wild and thundery night. Inside a ramshackle old manor house, a beautiful young girl lies asleep in bed. At the window, a figure watches... Continue »
  1. $18.90 Sale Hardcover add to wish list

    The Quick

    Lauren Owen 9780812993271

spacer
Qualifying orders ship free.
$3.98
Used Trade Paper
Ships in 1 to 3 days
Add to Wishlist
Qty Store Section
1 Local Warehouse Microsoft Windows- Windows 95 General

Excel 2002 Power Programming with VBA (Professional Mindware)

by

Excel 2002 Power Programming with VBA (Professional Mindware) Cover

 

Out of Print

Synopses & Reviews

Publisher Comments:

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

Synopsis:

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

Synopsis:

M&T Books publishes top-quality references and guides for information technology professionals. Written for intermediate to advanced programmers, developers, Web designers, and network administrators, the series under the M&T Books imprint include:

Description:

System requirements for computer disc: Pentium IBM-compatible PC with Windows 98 or greater; 32 MB RAM; Microsoft Excel 2002.

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.

Table of Contents

Preface.

Acknowledgments.

PART I: Some Essential Background.

Chapter 1: Excel 2002: Where It Came From.

Chapter 2: Excel in a Nutshell.

Chapter 3: Formula Tricks and Techniques.

Chapter 4: Understanding Excel's Files.

PART II: Excel Application Development.

Chapter 5: What is a Spreadsheet Application?

Chapter 6: Essentials of Spreadsheet Application Development.

PART III: Understanding Visual Basic for Applications.

Chapter 7: Introducing Visual Basic for Applications.

Chapter 8: VBA Programming Fundamentals.

Chapter 9: Working with VBA Sub Procedures.

Chapter 10: Creating Function Procedures.

Chapter 11: VBA Programming Examples and Techniques.

PART IV: Working with UserForms.

Chapter 12: Custom Dialog Box Alternatives.

Chapter 13: Introducing UserForms.

Chapter 14: UserForm Examples.

Chapter 15: Advanced UserForm Techniques.

PART V: Advanced Programming Techniques.

Chapter 16: Developing Excel Utilities with VBA.

Chapter 17: Working with Pivot Tables.

Chapter 18: Working with Charts.

Chapter 19: Understanding Excel's Events.

Chapter 20: Interacting with Other Applications.

Chapter 21: Creating and Using Add-Ins.

PART VI: Developing Applications.

Chapter 22: Creating Custom Toolbars.

Chapter 23: Creating Custom Menus.

Chapter 24: Providing Help for Your Applications.

Chapter 25: Developing User-Oriented Applications.

PART VII: Other Topics.

Chapter 26: Compatibility Issues.

Chapter 27: Manipulating Files with VBA.

Chapter 28: Manipulating Visual Basic Components.

Chapter 29: Understanding Class Modules.

Chapter 30: Frequently Asked Questions about Excel Programming.

Appendix A: Excel Resources Online.

Appendix B: VBA Statements and Functions Reference.

Appendix C: VBA Error Codes.

Appendix D: ANSI Code Reference.

Appendix E: What's on the CD-ROM.

Index.

End-User License Agreement.

CD-ROM Installation Instructions.

Product Details

ISBN:
9780764547997
Author:
Walkenbach, John
Publisher:
Wiley
Location:
New York
Subject:
Programming - General
Subject:
Spreadsheets - Excel
Subject:
Electronic spreadsheets
Subject:
Computer software
Subject:
Programming - Visual Basic - VBA (Visual Basic for Applicati
Subject:
Microsoft Excel for Windows.
Subject:
Microsoft Excel
Subject:
Microsoft Visual Basic for Windows
Subject:
Computer software -- Development.
Subject:
Spreadsheets - General
Subject:
Personal Computers-Applications
Subject:
Personal Computers-Desktop Applications-Spreadsheets
Copyright:
Edition Description:
CD
Series:
Professional Mindware
Series Volume:
154
Publication Date:
20010715
Binding:
Electronic book text in proprietary or open standard format
Language:
English
Illustrations:
Yes
Pages:
984
Dimensions:
24 cm. +

Other books you might like

  1. Digital Photographer's Handbook Used Trade Paper $12.95
  2. The New Oxford American Dictionary Used Hardcover $24.50
  3. Make Way for Ducklings Used Book Club Paperback $2.50
  4. The True Story of the 3 Little Pigs
    Used Book Club Paperback $3.50
  5. Definitive Guide To Excel Vba 2ND... New Trade Paper $54.99
  6. The Finite Element Method: Linear... Used Trade Paper $15.95

Related Subjects

Computers and Internet » Computer Languages » BASIC
Computers and Internet » Computer Languages » Visual Basic
Computers and Internet » Operating Systems » Microsoft Windows » Windows 95 » General
Computers and Internet » Personal Computers » Desktop Applications » Spreadsheets

Excel 2002 Power Programming with VBA (Professional Mindware) Used Trade Paper
0 stars - 0 reviews
$3.98 In Stock
Product details 984 pages John Wiley & Sons - English 9780764547997 Reviews:
"Synopsis" by , Bonus: The book contains a coupon for the Professional Power Utility Pak.
"Synopsis" by , M&T Books publishes top-quality references and guides for information technology professionals. Written for intermediate to advanced programmers, developers, Web designers, and network administrators, the series under the M&T Books imprint include:
spacer
spacer
  • back to top
Follow us on...




Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.