 Microsoft Excel 2000 Power Programming with VBA
ISBN: 978-0-7645-3263-4
Paperback
912 pages
May 1999
US $49.99
 Add to Cart
This price is valid for United States. Change location to view local pricing and availability. |
Instructors may request an evaluation copy for this title.
|
Preface.
Acknowledgements.
PART I: Some Essential Background.
Chapter 1: Excel 2000: 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: Introducing UserForms.
Chapter 13: UserForm Examples.
Chapter 14: Advanced UserForm Techniques.
PART V: Advanced Programming Techniques.
Chapter 15: Developing Excel Utilities with VBA.
Chapter 16: Working with Pivot Tables.
Chapter 17: Working with Charts.
Chapter 18: Understanding Excel's Events.
Chapter 19: Interacting with Other Applications.
Chapter 20: Creating and Using Add-Ins.
PART VI: Developing Applications.
Chapter 21: Creating Custom Toolbars.
Chapter 22: Creating Custom Menus.
Chapter 23: Providing Help for Your Applications.
Chapter 24: Developing User-Oriented Applications.
PART VII: Other Topics.
Chapter 25: Compatibility Issues.
Chapter 26: Reading and Writing Text Files.
Chapter 27: Manipulating Visual Basic Components.
Chapter 28: Understanding Class Modules.
Chapter 29: 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.
Acknowledgements.
PART I: Some Essential Background.
Chapter 1: Excel 2000: 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: Introducing UserForms.
Chapter 13: UserForm Examples.
Chapter 14: Advanced UserForm Techniques.
PART V: Advanced Programming Techniques.
Chapter 15: Developing Excel Utilities with VBA.
Chapter 16: Working with Pivot Tables.
Chapter 17: Working with Charts.
Chapter 18: Understanding Excel's Events.
Chapter 19: Interacting with Other Applications.
Chapter 20: Creating and Using Add-Ins.
PART VI: Developing Applications.
Chapter 21: Creating Custom Toolbars.
Chapter 22: Creating Custom Menus.
Chapter 23: Providing Help for Your Applications.
Chapter 24: Developing User-Oriented Applications.
PART VII: Other Topics.
Chapter 25: Compatibility Issues.
Chapter 26: Reading and Writing Text Files.
Chapter 27: Manipulating Visual Basic Components.
Chapter 28: Understanding Class Modules.
Chapter 29: 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.
