Pro Excel 2007 VBA (eBook)

Jim DeMarco (Autor)

eBook Download: PDF

2008 | 1st ed.
361 Seiten
Apress (Verlag)
978-1-4302-0580-7 (ISBN)

Infos

This is a professionals' guide to understanding and implementing the key principles and techniques of programming Microsoft Office Excel 2007. Automating complex spreadsheets, streamlining time-intensive work processes, gaining the competitive edge, and making more money for your businesses: these are all reasons to take Excel to the next level. This book teaches how to do just that, with the author using his own real-life experience to develop your understanding to this professional level. The text teaches the most efficient way to create complex and feature rich VBA code, exposing all the new features and capabilities that make Excel 2007 so exciting.

A bio is not available for this author.

---

Pro Excel 2007 VBA is the complete guide to creating Excel VBA applications, including coverage of new features in Excel 2007. Covering object-oriented programming techniques, debugging, and error handling methodologies, this book quickly turns novice into expert as it explores COM and .NET components and the advantages of compiled code. The book also covers XML for Excel web development. This book is unique insomuch that author Jim DeMarco is a true expert in the field of Excel programming, and he conveys the Visual Basic for Applications story in the context of the real world. Not just another dry programming guide, Pro Excel 2007 VBA is a journey from novice to expert where the author is your traveling companion. Bon voyage!

Inhalt

Contents at a Glance 5
Contents 6
About the Author 10
About the Technical Reviewer 11
Acknowledgments 12
Introduction 13
Who This Book Is For 13
How This Book Is Structured 13
Prerequisites 14
Downloading the Code 15
Contacting the Author 15
The Macro Recorder and Code Modules 16
Macro Security Settings 16
The Visual Basic Development Environment 19
Recording a Macro 29
Writing a Macro in the VBE 35
The Object Browser 39
Standard Code Modules 42
Class Modules 44
UserForms 51
Object- Oriented Programming: An Overview 54
Summary 56
Data In, Data Out 57
Excel’s Data Import Tools 57
Using DAO in Excel 2007 68
Using ADO in Excel 2007 81
Of Excel, Data, and Object Orientation 101
Summary 110
Using XML in Excel 2007 112
Importing XML in Excel 2007 112
Appending XML Data 119
Saving XML Data 120
Building an XML Data Class 121
Adding a Custom Ribbon to Your Workbook 132
Summary 145
UserForms 146
Creating a Simple Data Entry Form 146
Creating Wizard- Style Data Entry UserForms 163
Summary 204
Charting in Excel 2007 205
Getting Started 205
Summarizing with Pie Charts 214
Summary 233
PivotTables 234
Putting Data into a PivotTable Report 234
Summary 258
Debugging and Error Handling 259
Debugging 259
Error Handling 285
Summary 295
Office Integration 297
Creating a Report in Word 297
Creating a PowerPoint Presentation 308
Summary 324
ActiveX and .NET 325
Using ActiveX Components in Your Excel 2007 Projects 325
Excel in the . NET World 333
Summary 360
Index 361

Produkt-Details

• Erscheint lt. Verlag: 29.5.2008
• Zusatzinfo: 361 p.
• Verlagsort: Berkeley
• Sprache: englisch
• Themenwelt: Informatik ► Office Programme ► Excel
• Themenwelt: Mathematik / Informatik ► Informatik ► Software Entwicklung
• Schlagworte: Excel • Excel 2007 • pivot table • PivotTable • programming • spreadsheet • VBA • Visual BASIC • Visual Basic for Applications
• ISBN-10: 1-4302-0580-6 / 1430205806
• ISBN-13: 978-1-4302-0580-7 / 9781430205807