Microsoft Office 2007 Programming (VSTO)

Chapter 1: Visual Studio Tools for Office (VSTO) - Page 18
What is Microsoft VSTO? - Page 19
What is Microsoft VSTO? - Page 20
Why VSTO 3.0? - Page 21
Data caching - Page 22
Smart tags - Page 23
Security improvements - Page 24
Maintainability - Page 25
Maintainability - Page 26
VSTO architecture - Page 27
Development approaches - Page 28
Application-oriented approach - Page 29
Application-oriented approach - Page 30
VSTO development environment - Page 31
Visual Studio integration - Page 32
Creating VSTO solutions - Page 33
Creating VSTO solutions - Page 34
Creating VSTO solutions - Page 35
Viewing IDE Windows - Page 36
Viewing IDE Windows - Page 37
Debugging - Page 38
What can we expect in the next version? - Page 39
Chapter 2: Microsoft Office InfoPath Programming - Page 40
Microsoft Office InfoPath - Page 41
Visual Studio 2008 InfoPath solution overview - Page 42
Visual Studio 2008 InfoPath solution overview - Page 43
The VSTO problem when installing Office InfoPath 2007 - Page 44
Creating our first example - Page 45
Creating our first example - Page 46
Available customization features - Page 47
Object model in InfoPath solution - Page 48
Understanding the Microsoft Office InfoPath object model - Page 49
Understanding the InfoPath object model functional area - Page 50
Understanding the InfoPath object model functional area - Page 51
Understanding the InfoPath object model functional area - Page 52
Using events in InfoPath - Page 53
Form-level events - Page 54
Form-level events - Page 55
Form-level events - Page 56
Form-level events - Page 57
Form-level events - Page 58
Form-level events - Page 59
Form-level events - Page 60
Form-level events - Page 61
Form-level events - Page 62
Form-level events - Page 63
Form-level events - Page 64
Form-level events - Page 65
Xml events - Page 66
Xml events - Page 67
Control events - Page 68
Writing event validation for an expense report form - Page 69
Writing event validation for an expense report form - Page 70
Writing event validation for an expense report form - Page 71
Writing event validation for an expense report form - Page 72
Writing event validation for an expense report form - Page 73
Manipulating a data source - Page 74
Assigning a value to a node in the main data source - Page 75
Adding or creating a new node in the main data source - Page 76
Deleting or removing nodes from the main data source - Page 77
Populating Microsoft Office InfoPath with Microsoft SQL Server 2008 - Page 78
Populating Microsoft Office InfoPath with Microsoft SQL Server 2008 - Page 79
Working with Custom Task Panes - Page 80
Creating an InfoPath Task Pane - Page 81
Creating an InfoPath Task Pane - Page 82
Creating an InfoPath Task Pane - Page 83
Creating an InfoPath add-in project using Visual Studio 2008 - Page 84
Creating an InfoPath add-in project using Visual Studio 2008 - Page 85
Creating an InfoPath add-in project using Visual Studio 2008 - Page 86
Creating an InfoPath add-in project using Visual Studio 2008 - Page 87
Creating an InfoPath add-in project using Visual Studio 2008 - Page 88
InfoPath and SharePoint workflow - Page 89
Summary - Page 90
Summary - Page 91
Chapter 3: Microsoft Office Word Programming - Page 92
Microsoft Office Word 2007 solutions - Page 93
Application-level solutions versus document-level solutions - Page 94
Application-level solutions versus document-level solutions - Page 95
Application-level solutions versus document-level solutions - Page 96
Publishing solution deployment - Page 97
Publishing solution deployment - Page 98
Working with objects and documents - Page 99
Working with objects and documents - Page 100
Working with key objects - Page 101
Selecting text in a Word 2007 document - Page 102
Creating a table in a Word 2007 document - Page 103
Creating a table in a Word 2007 document - Page 104
Working with Word templates - Page 105
Actions Pane: Document-level customization - Page 106
Managing the Actions Pane - Page 107
Managing the Actions Pane - Page 108
Designing the Actions Pane - Page 109
Application-level solutions - Page 110
Task Pane: Application-level customization - Page 111
Task Pane: Application-level customization - Page 112
Task Pane: Application-level customization - Page 113
Task Pane: Application-level customization - Page 114
Custom Task Pane - Page 115
Custom Task Pane - Page 116
Programming in Word - Page 117
Word host controls - Page 118
Adding controls to a document - Page 119
Adding an ActiveX control to Microsoft Office Word 2007 programmatically - Page 120
Adding an ActiveX control to Microsoft Office Word 2007 programmatically - Page 121
Adding an ActiveX control to Microsoft Office Word 2007 programmatically - Page 122
Data binding to host controls - Page 123
Data binding to host controls - Page 124
Data binding to host controls - Page 125
Data binding to host controls - Page 126
Data binding to host controls - Page 127
Data binding to host controls - Page 128
Data binding to host controls - Page 129
What is LINQ? - Page 130
Customization - Page 131
Ribbon menu - Page 132
Adding controls to menus - Page 133
Adding controls to menus - Page 134
Adding controls to menus - Page 135
Adding controls to menus - Page 136
Adding controls to menus - Page 137
Toolbar (Quick Access Toolbar) - Page 138
Toolbar (Quick Access Toolbar) - Page 139
Summary - Page 140
Summary - Page 141
Chapter 4: Microsoft Office Excel Programming - Page 142
Programming in Excel - Page 143
Hello World example using Visual Studio 2008 - Page 144
Hello World example using Visual Studio 2008 - Page 145
Hello World example using Visual Studio 2008 - Page 146
Manipulation - Page 147
Data manipulation - Page 148
Opening a text file as a workbook using VSTO - Page 149
Connecting with Microsoft SQL Server 2008 database - Page 150
Connecting with Microsoft SQL Server 2008 database - Page 151
Worksheet manipulation - Page 152
Worksheet manipulation - Page 153
Working with ranges - Page 154
Cells - Page 155
Unions - Page 156
Named ranges - Page 157
Excel host items - Page 158
The workbook host item - Page 159
The workbook host item - Page 160
The worksheet host item - Page 161
The ChartSheet host item - Page 162
The ChartSheet host item - Page 163
Excel host controls - Page 164
Chart control - Page 165
The ListObject control - Page 166
The NamedRange control - Page 167
The XMLMappedRange control - Page 168
Creating Excel smart tags with VSTO - Page 169
Creating Excel smart tags with VSTO - Page 170
Excel formulae - Page 171
Excel formulae - Page 172
Regular expressions - Page 173
Regular expressions - Page 174
Excel data protection - Page 175
Excel data protection - Page 176
Worksheet protection - Page 177
Chapter 5: Microsoft Office Outlook Programming - Page 178
Microsoft Office Outlook object model overview - Page 179
Microsoft Office Outlook object model overview - Page 180
Microsoft Office Outlook object model overview - Page 181
Customization using VSTO - Page 182
Menus in Outlook - Page 183
Menus in Outlook - Page 184
Menus in Outlook - Page 185
Menus in Outlook - Page 186
Menus in Outlook - Page 187
Outlook form regions support - Page 188
Outlook form regions support - Page 189
Outlook form regions support - Page 190
Outlook form regions support - Page 191
Outlook form regions support - Page 192
Outlook form regions support - Page 193
Manipulation - Page 194
Manipulation - Page 195
Manipulation - Page 196
Contacts - Page 197
Contacts - Page 198
Contacts - Page 199
Contacts - Page 200
Email messages - Page 201
Email messages - Page 202
Email messages - Page 203
Email messages - Page 204
Email messages - Page 205
Working with Appointments - Page 206
Working with Appointments - Page 207
Working with meetings - Page 208
Working with meetings - Page 209
Creating a Ribbon menu for Outlook 2007 - Page 210
Creating a Ribbon menu for Outlook 2007 - Page 211
Creating a Ribbon menu for Outlook 2007 - Page 212
Creating a Ribbon menu for Outlook 2007 - Page 213
Creating a Ribbon menu for Outlook 2007 - Page 214
Creating a Ribbon menu for Outlook 2007 - Page 215
Summary - Page 216
Summary - Page 217
Chapter 6: Microsoft Office PowerPoint, Visio, and Project Programming - Page 218
Programming PowerPoint 2007 - Page 219
Programming PowerPoint 2007 - Page 220
PowerPoint 2007 object model - Page 221
Creating a presentation at runtime - Page 222
Dynamically add a slide and set title text in the presentation - Page 223
Dynamically add a slide and set title text in the presentation - Page 224
Set the presentation theme - Page 225
Ribbons in PowerPoint - Page 226
Creating a Ribbon - Page 227
Creating a Ribbon - Page 228
Creating a Ribbon - Page 229
Creating a Ribbon - Page 230
Creating a Ribbon - Page 231
Programming Visio 2007 - Page 232
Programming Visio 2007 - Page 233
Visio 2007 object model - Page 234
Dynamically creating a new Visio document - Page 235
Adding shapes to a document at runtime - Page 236
Adding shapes to a document at runtime - Page 237
Adding a page as a background for another page - Page 238
Adding a page as a background for another page - Page 239
Adding a page as a background for another page - Page 240
Set the document theme - Page 241
Creating a Commandbar - Page 242
Creating a Commandbar - Page 243
Programming Project 2007 - Page 244
Programming Project 2007 - Page 245
Creating a Project and adding a task dynamically - Page 246
Creating a Project and adding a task dynamically - Page 247
Creating menus for Microsoft Project - Page 248
Creating a Commandbar for Microsoft Project - Page 249
Creating a Commandbar for Microsoft Project - Page 250
Summary - Page 251