Jeff Webb is one of the original Visual Basic team members. He was intensely involved with Excel VBA and conceived the first Office Developer's Kit. Jeff also wrote the first book on Excel VBA, Using Excel Visual Basic for Applications, which has remained in print for an amazing 12 years. Now, he returns to his favorite subject with a completely new, comprehensive guide: Programming Excel with VBA and VB .NET.

Steve Saunders is a Microsoft veteren who helped pioneer the design of hypertext help systems that paved the way for the design of today's Web sites. He was lead designer for the award-winning Microsoft Access and Basic help systems, and was a charter member of the Visual Basic product team. Later, Steve wrote documentation for Access programmers and became an Access programmer himself, creating applications for his group at Microsoft and for a growing list of clients outside the company.

Businesses and non-profit organizations use Steve's affordable custom applications to track their critical information, including customers and orders, lodging reservations, real estate listings, donors and donations. Since 1996, the Methow Valley Sport Trails Association (MVSTA) has used his race management application, Racetracker, to produce accurate and timely results for its popular cross-country ski and running races.

Before his years at Microsoft, Steve was a reporter and editor for newspapers in Utah, Maine, and Massachusetts, and a technical writer in the database group at Digital Equipment Corp. He holds a master's degree in journalism from Boston University, a graduate certificate in technical writing from Northeastern University, and a bachelor's degree in technical writing and creative writing from Carnegie-Mellon University.

Currently a principal of Smiling Country, Steve enjoys combining his technical, design, and editorial expertise to help businesses succeed.

Preface;
Learn by Doing;
Don't Force It;
Excel Versions;
Get the Samples;
What's in This Book;
Font Conventions;
Syntax Conventions;
Using Code Examples;
Safari® Enabled;
How to Contact Us;
Acknowledgments;
Part I: Learning VBA;
Chapter 1: Becoming an Excel Programmer;
1.1 Why Program?;
1.2 Record and Read Code;
1.3 Change Recorded Code;
1.4 Fix Misteakes;
1.5 Start and Stop;
1.6 View Results;
1.7 Where's My Code?;
1.8 Macros and Security;
1.9 Write Bug-Free Code;
1.10 Navigate Samples and Help;
1.11 What You've Learned;
Chapter 2: Knowing the Basics;
2.1 Parts of a Program;
2.2 Classes and Modules;
2.3 Procedures;
2.4 Variables;
2.5 Conditional Statements;
2.6 Loops;
2.7 Expressions;
2.8 Exceptions;
2.9 What You've Learned;
Chapter 3: Tasks in Visual Basic;
3.1 Types of Tasks;
3.2 Interact with Users;
3.3 Do Math;
3.4 Work with Text;
3.5 Get Dates and Times;
3.6 Read and Write Files;
3.7 Check Results;
3.8 Find Truth;
3.9 Compare Bits;
3.10 Run Other Applications;
3.11 Control the Compiler;
3.12 Not Covered Here;
3.13 What You've Learned;
Chapter 4: Using Excel Objects;
4.1 Objects and Their Members;
4.2 Get Excel Objects;
4.3 Get Objects from Collections;
4.4 About Me and the Active Object;
4.5 Find the Right Object;
4.6 Common Members;
4.7 Respond to Events in Excel;
4.8 The Global Object;
4.9 The WorksheetFunction Object;
4.10 What You've Learned;
Chapter 5: Creating Your Own Objects;
5.1 Modules Versus Classes;
5.2 Add Methods;
5.3 Create Properties;
5.4 Define Enumerations;
5.5 Raise Events;
5.6 Collect Objects;
5.7 Expose Objects;
5.8 Destroy Objects;
5.9 Things You Can't Do;
5.10 What You've Learned;
Chapter 6: Writing Code for Use by Others;
6.1 Types of Applications;
6.2 The Development Process;
6.3 Determine Requirements;
6.4 Design;
6.5 Implement and Test;
6.6 Integrate;
6.7 Test Platforms;
6.8 Document;
6.9 Deploy;
6.10 What You've Learned;
6.11 Resources;
Part II: Excel Objects;
Chapter 7: Controlling Excel;
7.1 Perform Tasks;
7.2 Control Excel Options;
7.3 Get References;
7.4 Application Members;
7.5 AutoCorrect Members;
7.6 AutoRecover Members;
7.7 ErrorChecking Members;
7.8 SpellingOptions Members;
7.9 Window and Windows Members;
7.10 Pane and Panes Members;
Chapter 8: Opening, Saving, and Sharing Workbooks;
8.1 Add, Open, Save, and Close;
8.2 Share Workbooks;
8.3 Program with Shared Workbooks;
8.4 Program with Shared Workspaces;
8.5 Respond to Actions;
8.6 Workbook and Workbooks Members;
8.7 RecentFile and RecentFiles Members;
Chapter 9: Working with Worksheets and Ranges;
9.1 Work with Worksheet Objects;
9.2 Worksheets and Worksheet Members;
9.3 Sheets Members;
9.4 Work with Outlines;
9.5 Outline Members;
9.6 Work with Ranges;
9.7 Range Members;
9.8 Work with Scenario Objects;
9.9 Scenario and Scenarios Members;
9.10 Resources;
Chapter 10: Linking and Embedding;
10.1 Add Comments;
10.2 Use Hyperlinks;
10.3 Link and Embed Objects;
10.4 Speak;
10.5 Comment and Comments Members;
10.6 Hyperlink and Hyperlinks Members;
10.7 OleObject and OleObjects Members;
10.8 OLEFormat Members;
10.9 Speech Members;
10.10 UsedObjects Members;
Chapter 11: Printing and Publishing;
11.1 Print and Preview;
11.2 Control Paging;
11.3 Change Printer Settings;
11.4 Filter Ranges;
11.5 Save and Display Views;
11.6 Publish to the Web;
11.7 AutoFilter Members;
11.8 Filter and Filters Members;
11.9 CustomView and CustomViews Members;
11.10 HPageBreak, HPageBreaks, VPageBreak, VPageBreaks Members;
11.11 PageSetup Members;
11.12 Graphic Members;
11.13 PublishObject and PublishObjects Members;
11.14 WebOptions and DefaultWebOptions Members;
Chapter 12: Loading and Manipulating Data;
12.1 Working with QueryTable Objects;
12.2 QueryTable and QueryTables Members;
12.3 Working with Parameter Objects;
12.4 Parameter Members;
12.5 Working with ADO and DAO;
12.6 ADO Objects and Members;
12.7 DAO Objects and Members;
12.8 DAO.Database and DAO.Databases Members;
12.9 DAO.Document and DAO.Documents Members;
12.10 DAO.QueryDef and DAO.QueryDefs Members;
12.11 DAO.Recordset and DAO.Recordsets Members;
Chapter 13: Analyzing Data with Pivot Tables;
13.1 Quick Guide to Pivot Tables;
13.2 Program Pivot Tables;
13.3 PivotTable and PivotTables Members;
13.4 PivotCache and PivotCaches Members;
13.5 PivotField and PivotFields Members;
13.6 CalculatedFields Members;
13.7 CalculatedItems Members;
13.8 PivotCell Members;
13.9 PivotFormula and PivotFormulas Members;
13.10 PivotItem and PivotItems Members;
13.11 PivotItemList Members;
13.12 PivotLayout Members;
13.13 CubeField and CubeFields Members;
13.14 CalculatedMember and CalculatedMembers Members;
Chapter 14: Sharing Data Using Lists;
14.1 Use Lists;
14.2 ListObject and ListObjects Members;
14.3 ListRow and ListRows Members;
14.4 ListColumn and ListColumns Members;
14.5 ListDataFormat Members;
14.6 Use the Lists Web Service;
14.7 Lists Web Service Members;
14.8 Resources;
Chapter 15: Working with XML;
15.1 Understand XML;
15.2 Save Workbooks as XML;
15.3 Use XML Maps;
15.4 Program with XML Maps;
15.5 XmlMap and XmlMaps Members;
15.6 XmlDataBinding Members;
15.7 XmlNamespace and XmlNamespaces Members;
15.8 XmlSchema and XmlSchemas Members;
15.9 Get an XML Map from a List or Range;
15.10 XPath Members;
15.11 Resources;
Chapter 16: Charting;
16.1 Navigate Chart Objects;
16.2 Create Charts Quickly;
16.3 Embed Charts;
16.4 Create More Complex Charts;
16.5 Choose Chart Type;
16.6 Create Combo Charts;
16.7 Add Titles and Labels;
16.8 Plot a Series;
16.9 Respond to Chart Events;
16.10 Chart and Charts Members;
16.11 ChartObject and ChartObjects Members;
16.12 ChartGroup and ChartGroups Members;
16.13 SeriesLines Members;
16.14 Axes and Axis Members;
16.15 DataTable Members;
16.16 Series and SeriesCollection Members;
16.17 Point and Points Members;
Chapter 17: Formatting Charts;
17.1 Format Titles and Labels;
17.2 Change Backgrounds and Fonts;
17.3 Add Trendlines;
17.4 Add Series Lines and Bars;
17.5 ChartTitle, AxisTitle, and DisplayUnitLabel Members;
17.6 DataLabel and DataLabels Members;
17.7 LeaderLines Members;
17.8 ChartArea Members;
17.9 ChartFillFormat Members;
17.10 ChartColorFormat Members;
17.11 DropLines and HiLoLines Members;
17.12 DownBars and UpBars Members;
17.13 ErrorBars Members;
17.14 Legend Members;
17.15 LegendEntry and LegendEntries Members;
17.16 LegendKey Members;
17.17 Gridlines Members;
17.18 TickLabels Members;
17.19 Trendline and Trendlines Members;
17.20 PlotArea Members;
17.21 Floor Members;
17.22 Walls Members;
17.23 Corners Members;
Chapter 18: Drawing Graphics;
18.1 Draw in Excel;
18.2 Create Diagrams;
18.3 Program with Drawing Objects;
18.4 Program Diagrams;
18.5 Shape, ShapeRange, and Shapes Members;
18.6 Adjustments Members;
18.7 CalloutFormat Members;
18.8 ColorFormat Members;
18.9 ConnectorFormat Members;
18.10 ControlFormat Members;
18.11 FillFormat Members;
18.12 FreeFormBuilder;
18.13 GroupShapes Members;
18.14 LineFormat Members;
18.15 LinkFormat Members;
18.16 PictureFormat Members;
18.17 ShadowFormat;
18.18 ShapeNode and ShapeNodes Members;
18.19 TextFrame;
18.20 TextEffectFormat;
18.21 ThreeDFormat;
Chapter 19: Adding Menus and Toolbars;
19.1 About Excel Menus;
19.2 Build a Top-Level Menu;
19.3 Create a Menu in Code;
19.4 Build Context Menus;
19.5 Build a Toolbar;
19.6 Create Toolbars in Code;
19.7 CommandBar and CommandBars Members;
19.8 CommandBarControl and CommandBarControls Members;
19.9 CommandBarButton Members;
19.10 CommandBarComboBox Members;
19.11 CommandBarPopup Members;
Chapter 20: Building Dialog Boxes;
20.1 Types of Dialogs;
20.2 Create Data-Entry Forms;
20.3 Design Your Own Forms;
20.4 Use Controls on Worksheets;
20.5 UserForm and Frame Members;
20.6 Control and Controls Members;
20.7 Font Members;
20.8 CheckBox, OptionButton, ToggleButton Members;
20.9 ComboBox Members;
20.10 CommandButton Members;
20.11 Image Members;
20.12 Label Members;
20.13 ListBox Members;
20.14 MultiPage Members;
20.15 Page Members;
20.16 ScrollBar and SpinButton Members;
20.17 TabStrip Members;
20.18 TextBox and RefEdit Members;
Chapter 21: Sending and Receiving Workbooks;
21.1 Send Mail;
21.2 Work with Mail Items;
21.3 Collect Review Comments;
21.4 Route Workbooks;
21.5 Read Mail;
21.6 MsoEnvelope Members;
21.7 MailItem Members;
21.8 RoutingSlip Members;
Part III: Extending Excel;
Chapter 22: Building Add-ins;
22.1 Types of Add-ins;
22.2 Code-Only Add-ins;
22.3 Visual Add-ins;
22.4 Set Add-in Properties;
22.5 Sign the Add-in;
22.6 Distribute the Add-in;
22.7 Work with Add-ins in Code;
22.8 AddIn and AddIns Members;
Chapter 23: Integrating DLLs and COM;
23.1 Use DLLs;
23.2 Use COM Applications;
Chapter 24: Getting Data from the Web;
24.1 Perform Web Queries;
24.2 QueryTable and QueryTables Web Query Members;
24.3 Use Web Services;
24.4 Resources;
Chapter 25: Programming Excel with .NET;
25.1 Approaches to Working with .NET;...