DeMarco Pro Excel 2007 VBA

1. ed
ISBN: 978-1-4302-0580-7
Verlag: Apress
Format: PDF
Kopierschutz: 1 - PDF Watermark

E-Book, Englisch, 361 Seiten

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.

Autoren/Hrsg.

DeMarco, Jim

Inhaltsverzeichnis

1;Contents at a Glance;5
2;Contents;6
3;About the Author;10
4;About the Technical Reviewer;11
5;Acknowledgments;12
6;Introduction;13
6.1;Who This Book Is For;13
6.2;How This Book Is Structured;13
6.3;Prerequisites;14
6.4;Downloading the Code;15
6.5;Contacting the Author;15
7;The Macro Recorder and Code Modules;16
7.1;Macro Security Settings;16
7.2;The Visual Basic Development Environment;19
7.3;Recording a Macro;29
7.4;Writing a Macro in the VBE;35
7.5;The Object Browser;39
7.6;Standard Code Modules;42
7.7;Class Modules;44
7.8;UserForms;51
7.9;Object- Oriented Programming: An Overview;54
7.10;Summary;56
8;Data In, Data Out;57
8.1;Excel’s Data Import Tools;57
8.2;Using DAO in Excel 2007;68
8.3;Using ADO in Excel 2007;81
8.4;Of Excel, Data, and Object Orientation;101
8.5;Summary;110
9;Using XML in Excel 2007;112
9.1;Importing XML in Excel 2007;112
9.2;Appending XML Data;119
9.3;Saving XML Data;120
9.4;Building an XML Data Class;121
9.5;Adding a Custom Ribbon to Your Workbook;132
9.6;Summary;145
10;UserForms;146
10.1;Creating a Simple Data Entry Form;146
10.2;Creating Wizard- Style Data Entry UserForms;163
10.3;Summary;204
11;Charting in Excel 2007;205
11.1;Getting Started;205
11.2;Summarizing with Pie Charts;214
11.3;Summary;233
12;PivotTables;234
12.1;Putting Data into a PivotTable Report;234
12.2;Summary;258
13;Debugging and Error Handling;259
13.1;Debugging;259
13.2;Error Handling;285
13.3;Summary;295
14;Office Integration;297
14.1;Creating a Report in Word;297
14.2;Creating a PowerPoint Presentation;308
14.3;Summary;324
15;ActiveX and .NET;325
15.1;Using ActiveX Components in Your Excel 2007 Projects;325
15.2;Excel in the . NET World;333
15.3;Summary;360
16;Index;361