Help  |   Contact Us  |   About Us  |   News and Events
Books, conferences, and other information about... Moving to Linux Switching to OOo Building Linux Apps Using Visual FoxPro
Buy      Download      Your Account      Catalog      Support      Conferences      Resources      Fun

Microsoft Office Automation with Visual FoxPro
Table of Contents


Section 1-Getting Starteds
Chapter 1: Introducing Automation
Chapter 2: The Office Servers
Chapter 3: Visual FoxPro as an Automation Client

Section 2-Automating Word
Chapter 4: Automating Word
Chapter 5: Intermediate Word
Chapter 6: Advanced Word

Section III-Automating Excel
Chapter 7: Excel Basics
Chapter 8: Advanced Excel Features
Chapter 9: Excel's Graphing Engine

Section IV-Automating PowerPoint
Chapter 10: PowerPoint Basics
Chapter 11: PowerPoint Advanced Features

Section V-Automating Outlook
Chapter 12: Automating Outlook

Section VI-Advanced Topics
Chapter 13: Inter-Office Communication
Chapter 14: Handling Automation Errors
Chapter 15: Wrapping Up the Servers

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