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 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 D 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 - 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 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