Microsoft Office Automation with Visual FoxPro

ISBN: 0965509303
EAN: 2147483647

Year: 2000
Pages: 128

Authors: Tamar Granor, Della Martin

BUY ON AMAZON

Microsoft Office Automation with Visual FoxPro
Introduction
Dedication
Acknowledgements
Chapter 1 - Introducing Automation
1.1 If all you have is a hammer, does that make everything a nail?
1.2 A brief history of Automation
1.3 Putting Automation to work
1.4 Where do you go from here?
Chapter 2 - The Office Servers
2.1 Exploring the Office servers
2.2 Taking up a collection
2.3 Self-referential object models
Chapter 3 - Visual FoxPro as an Automation Client
3.1 Managing servers
3.2 Working with servers
3.3 Debugging
3.4 Time for code
Chapter 4 - Word Basics
4.1 Word s object model
4.2 Getting to Word
4.3 Managing documents
4.4 Accessing parts of a document
4.5 Formatting
4.5.1 Setting up pages
4.5.2 Setting fonts
4.5.3 Formatting paragraphs
4.5.4 Working with styles
4.5.5 Borders and shading
4.5.6 Headers and footers
4.5.7 Organizing text with lists
4.6 Output
4.7 Putting it all together
Chapter 5 - Intermediate Word
5.1 Document templates
5.2 Tables
5.3 Creating multi-column documents
5.4 Footnotes and endnotes
5.5 Adding graphics to documents
5.6 Working with existing documents
5.7 Automating macros
5.8 Putting it all together
Chapter 6 - Advanced Word
6.1 Organizing a document using styles
6.2 Creating indexes
6.3 Merging documents with data
6.4 Putting it all together
Chapter 7 - Excel Basics
7.1 The object model
7.2 Dj vu
7.3 Getting a handle on the application
7.4 Managing workbooks and worksheets
7.5 Handling values and formulas
7.6 Formatting
7.6.1 Column widths and alignment
7.6.2 Fonts
7.6.3 Formatting values
7.6.4 Shading
7.6.5 Styles
7.7 Output
7.8 Putting it all together
Chapter 8 - Advanced Excel Features
8.1 PivotTables
8.1.1 PivotTable data
8.1.2 Creating a PivotTable
8.2 What-if analysis using data tables
8.3 Goal Seek
8.4 Protection
8.5 Templates
8.6 Automating macros
8.7 Adding shapes
8.8 Adding pictures
8.9 Putting it all together
Chapter 9 - Excel s Graphing Engine
9.1 The object model
9.2 Setting up the data
9.3 Creating a graph
9.4 Formatting the components
9.5 The Chart object
9.6 Putting it all together
Chapter 10 - PowerPoint Basics
10.1 The PowerPoint object model
10.2 Dj vu
10.3 Getting a handle on the application
10.4 Managing presentations and slides
10.5 Working with slide contents
10.6 Putting it all together
Chapter 11 - PowerPoint Advanced Features
11.1 Achieving consistency with Master Slides
11.1.1 Backgrounds
11.1.2 Standardizing the appearance of text
11.1.3 Standardizing colors with ColorSchemes
11.1.4 More on SlideMaster shapes
11.2 Fancy features
11.3 Multimedia
11.4 Adding notes
11.5 Putting it all together
Chapter 12 - Automating Outlook
12.1 The Outlook object model
12.2 Getting a handle on Outlook
12.3 Accessing Outlook s contents
12.4 Sending e-mail
12.5 Manipulating the Contacts folder
12.6 Adding appointments and tasks
12.7 Putting it all together
Chapter 13 - Inter-Office Communication
13.1 Communicating between Office applications
13.2 Communicating events with VFPCOM
13.3 The last word
Chapter 14 - Handling Automation Errors
14.1 Automation-specific errors
14.2 The war of 1426-1429
14.3 Error-handling strategies
14.4 Wrapping it up
Chapter 15 - Wrapping Up the Servers
15.1 Why wrap the servers?
15.2 Structuring the wrapper classes
15.3 Fundamental operations
15.4 Creating subclasses
15.5 Using the fundamental operations
15.6 Adding server-specific operations
15.7 Wrapping it up
Appendix A - On-line User Communities
A-1 FoxPro resources
A-2 Office resources
A-3 On-line etiquette