|
|
"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". It contains 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; and 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. The 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[trademark] or later". "Microsoft Excel 2003" - see the 'What's on the CD' Appendix for details and complete system requirements.
| ISBN | 0764540726 | | Pages | 1056 | | ISBN13 | 9780764540721
(What's this?) | | Volumes | 1 | | Publisher | John Wiley & Sons Inc | | Weight (grammes) | 1478 | | Imprint | Hungry Minds Inc,U.S. | | Published in | Foster City | | Format | Paperback | | Previous ISBN | 9780764547997 | | Publication date | 20 Jan 2004 | | Height (mm) | 236 | | Library of Congress | HF5548.4.M | | Width (mm) | 190 | | DEWEY | 005.369 | | Spine width (mm) | 53 | | DEWEY edition | DC22 | | Academic level | Professional / Scholarly |
|
| |
| | | Preface | | | | | | Acknowledgments | | | | Pt. I | | Some Essential Background | | | | Ch. 1 | | Excel 2003: Where It Came From | | 3 | | Ch. 2 | | Excel in a Nutshell | | 15 | | Ch. 3 | | Formula Tricks and Techniques | | 43 | | Ch. 4 | | Understanding Excel's Files | | 69 | | Pt. II | | Excel Application Development | | | | Ch. 5 | | What is a Spreadsheet Application? | | 93 | | Ch. 6 | | Essentials of Spreadsheet Application Development | | 105 | | Pt. III | | Understanding Visual Basic for Applications | | | | Ch. 7 | | Introducing Visual Basic for Applications | | 129 | | Ch. 8 | | VBA Programming Fundamentals | | 189 | | Ch. 9 | | Working with VBA Sub Procedures | | 237 | | Ch. 10 | | Creating Function Procedures | | 277 | | Ch. 11 | | VBA Programming Examples and Techniques | | 315 | | Pt. IV | | Working with UseForms | | | | Ch. 12 | | Custom Dialog Box Alternatives | | 385 | | Ch. 13 | | Introducing UserForms | | 407 | | Ch. 14 | | UserForm Examples | | 443 | | Ch. 15 | | Advanced UserForm Techniques | | 473 | | Pt. V | | Advanced Programming Techniques | | | | Ch. 16 | | Developing Excel Utilities with VBA | | 513 | | Ch. 17 | | Working with Pivot Tables | | 531 | | Ch. 18 | | Working with Charts | | 547 | | Ch. 19 | | Understanding Excel's Events | | 605 | | | More... | | |
|
|
|
|
|
Enlarge
