Table of Contents

Microsoft Excel 2003 Programming Inside Out
by Curtis Frye, Wayne S. Freeze and Felicia K. Buckingham	ISBN:0735619859
Microsoft Press 2004 (594 pages)
Take your Microsoft Office experience to the next level by programming custom business solutions with Excel 2003. This supremely organized reference and tutorial packs hundreds of timesaving answers, tips, and workarounds for advanced Excel users.

Table of Contents
	Microsoft Office Excel 2003 Programming Inside Out
	Part 1 - Preliminaries
	Chapter 1	-	What’s New in Excel 2003
	Chapter 2	-	Exploring Excel
	Part 2 - Visual Basic for Applications
	Chapter 3	-	Exploring Visual Basic for Applications
	Chapter 4	-	VBA Programming Starter Kit
	Chapter 5	-	Creating Sub and Function Procedures
	Part 3 - The Excel Object Model
	Chapter 6	-	The Application Object
	Chapter 7	-	Workbooks and Worksheets
	Chapter 8	-	Ranges and Cells
	Part 4 - Advanced VBA
	Chapter 9	-	Manipulating Data with VBA
	Chapter 10	-	Formatting Excel Objects
	Chapter 11	-	Creating Add-Ins and COM Add-Ins
	Chapter 12	-	Understanding and Using Events
	Chapter 13	-	Manipulating Files
	Chapter 14	-	Developing Class Modules
	Part 5 - Manipulating Excel Objects
	Chapter 15	-	Charts
	Chapter 16	-	PivotTables and PivotCharts
	Chapter 17	-	Command Bars
	Chapter 18	-	Customizing Dialog Boxes
	Chapter 19	-	Creating User Forms
	Chapter 20	-	Creating Advanced User Forms
	Part 6 - Excel and the Outside World—Collaborating Made Easy
	Chapter 21	-	Excel and Other Office Applications
	Chapter 22	-	Excel and the Structured Query Language
	Chapter 23	-	Introducing ADO
	Chapter 24	-	Excel Query Program
	Chapter 25	-	Excel and the Web
	Chapter 26	-	Excel and the Extensible Markup Language (XML)
	Index
	List of Figures
	List of Tables
	List of Inside Out
	List of Sidebars
	List of Troubleshooting