Dedication -- Our Contract with You, The Reader -- List of Chapters -- Table of Contents -- Acknowledgements -- About the Authors -- How to Download the Files -- Introduction -- Section I Getting Started -- Chapter 1 Introducing Automation -- If all you have is a hammer, does that make everything a nail? -- A brief history of Automation -- OLE or ActiveX or COM or what? -- Putting Automation to work -- Where do you go from here? -- Chapter 2 The Office Servers -- Exploring the Office servers -- Read the fine manual (RTFM) -- Let the server write the code -- Take me for a browse -- At your command -- On-line and print resources -- Taking up a collection -- Changing the collection -- Self-referential object models -- Moving on -- Chapter 3 Visual FoxPro as an Automation Client -- Managing servers -- Displaying the Office servers -- Are we there yet? -- Working with servers -- SET OLEOBJECT -- Use WITH…ENDWITH -- Use variables for object references -- Loop with FOR EACH -- Debugging -- Work in the Command Window -- Collections and objects -- It works, but it doesn't -- Parameter problems -- Unhelpful error messages -- Use the Knowledge Base -- Ask around -- Time for code -- Section II Automating Word -- Chapter 4 Word Basics -- Word's object model -- Getting to Word -- Managing documents -- Accessing parts of a document -- Manipulating text -- Moving in a range or selection -- Bookmarks -- Formatting -- Setting up pages -- Setting fonts -- Formatting paragraphs -- Working with styles -- Borders and shading -- Headers and footers -- Page numbering -- Organizing text with lists -- Output -- Printing -- Print preview -- Putting it all together -- Chapter 5 Intermediate Word -- Document templates -- What goes into a template? -- Finding templates -- Using templates -- Creating templates -- Putting templates to work -- Tables -- Irregular tables.

Creating multi-column documents -- Footnotes and endnotes -- Adding graphics to documents -- The two faces of graphics -- Working with existing documents -- Search and replace -- Exploring document structure -- Traversing a document with the collections -- Automating macros -- Putting it all together -- Chapter 6 Advanced Word -- Organizing a document using styles -- Working with outlines -- Creating a table of contents -- Creating indexes -- Deciding what to index -- Marking items for the index -- Generating the index -- Formatting indexes -- Merging documents with data -- Word's mail merge structure -- Substituting data with Find and Replace -- Drop back 10 yards and punt -- Putting it all together -- Section III Automating Excel -- Chapter 7 Excel Basics -- The object model -- Déjà vu -- Getting a handle on the application -- Managing workbooks and worksheets -- Opening a new workbook -- Opening an existing workbook -- Saving the workbook -- Working with worksheets -- Rows, columns, cells, and ranges -- Handling values and formulas -- Adding, copying, and moving data (including formulas) -- Fill 'er up -- Formatting -- Column widths and alignment -- Fonts -- Formatting values -- Borders -- Shading -- Styles -- Output -- Page Setup -- Print Preview -- Printing -- Saving the data in different formats -- Putting it all together -- Chapter 8 Advanced Excel Features -- PivotTables -- PivotTable data -- Creating a PivotTable -- What-if analysis using data tables -- Goal Seek -- Protection -- Protecting a cell -- Protecting a worksheet -- Protecting a workbook -- Templates -- What goes into a template? -- Finding templates -- Using templates -- Creating templates -- Automating macros -- Adding shapes -- Adding pictures -- Putting it all together -- Chapter 9 Excel's Graphing Engine -- The object model -- Is it a chart or a sheet? -- Setting up the data.

Range names are your friend -- Creating a graph -- The ActiveChart property -- Off to see the wizard -- The anatomy of a chart -- Formatting the components -- The Chart object -- Chart types -- Chart object properties available only to 3D charts -- ChartArea -- The Border object -- The Interior object -- The Font object -- The PlotArea object -- Data series -- The Legend object -- Axes -- Titles -- Putting it all together -- Section IV Automating PowerPoint -- Chapter 10 PowerPoint Basics -- The PowerPoint object model -- Déjà vu -- Getting a handle on the application -- Managing presentations and slides -- Presenting: the Presentation object -- Opening an existing presentation -- Adding slides -- Saving the presentation -- Closing presentations -- Closing the application object -- Making it look good for the users -- Working with slide contents -- Using the slide layouts -- Adding and formatting text -- Making it presentable -- Putting it all together -- Chapter 11 PowerPoint Advanced Features -- Achieving consistency with Master Slides -- Backgrounds -- Standardizing the appearance of text -- Standardizing colors with ColorSchemes -- More on SlideMaster shapes -- Fancy features -- Animations -- Transitions -- Taking action -- Multimedia -- Sounding off -- Motion -- Adding notes -- Putting it all together -- Section V Automating Outlook -- Chapter 12 Automating Outlook -- The Outlook object model -- Getting a handle on Outlook -- Accessing Outlook's contents -- Sending e-mail -- Recipients and contacts -- Attaching files -- Manipulating the Contacts folder -- Adding appointments and tasks -- Putting it all together -- Section VI Advanced Topics -- Chapter 13 Inter-Office Communication -- Communicating between Office applications -- Copying and pasting between applications -- PasteSpecial -- Using AddOLEObject -- Communicating events with VFPCOM.

Obtaining VFPCOM.DLL -- Using VFPCOM.DLL -- The last word -- Chapter 14 Handling Automation Errors -- Automation-specific errors -- The war of 1426-1429 -- Subtle differences -- Some interesting error observations -- Error-handling strategies -- ON ERROR and the Error method -- Preventing errors -- Wrapping it up -- Chapter 15 Wrapping Up the Servers -- Why wrap the servers? -- Structuring the wrapper classes -- Fundamental operations -- Talking to the user -- Creating a server instance -- Closing the server -- Opening a document -- Saving a document -- Other basic operations -- Creating subclasses -- Closing servers -- Opening a document, part 2 -- Closing a document -- Creating new documents -- Checking the server -- Checking open documents -- Keeping track of the active document -- Displaying the server -- Using the fundamental operations -- Adding server-specific operations -- Wrapping Word-from table to table -- Wrapping Excel-from table to graph -- Wrapping PowerPoint-standardizing text -- Wrapping it up -- Appendices -- Appendix A On-line User Communities -- FoxPro resources -- Office resources -- On-line etiquette -- Appendix B ChartWizard Values -- Index.