Microsoft Office Tutorials and References
In Depth Information
The preceding image represents the Microsoft Office 2007 Solution Logical
Architecture. VSTO enables Office developers to build document-level
customizations for InfoPath, Word, and Excel documents, whereas for Outlook,
PowerPoint, and Visio, there are no document-level customization features
supported by VSTO.
VSTO provides very good support for object-oriented programming, a feature
lacking in VBA scripting. VSTO provides full support for the C# programming
language, allowing the implementation of object-oriented programming in Office
solutions. Object-oriented programming is a kind of programming that relates
coding blocks to objects. In other words, object-oriented programming is a software
programming approach in which the structures of a program are based on objects'
interaction with other objects, in order to perform or execute tasks.VSTO has several
objects to work with in order to create applications using VSTO 3.0.
The architectural design of VSTO helps the Office developer in programming
separately for application and data. The VSTO architecture design provides
enhanced support for developing application-level solutions, and it exposes
various objects that will make it easier for Office developers to program for Office
applications. The most important point that you have to understand is that Word
and Excel are the editors for the data they represent. Using these editors, you can
edit and format the visually-displayed data. VSTO exposes a wide range of objects
for enhancing the application and for processing the data inside the application
for all of the Office applications that support it. Developing application level and
document-level solutions is another architectural advancement in VSTO.
The types of solutions that we can create by using VSTO 3.0 fall into two
categories, which we will use throughout this topic—document-level solutions,
and application-level solutions. Let's discuss each briefly.
The document-oriented approach is designed specifically to get to the
core of a Word or Excel document and include information that the document
wasn't originally designed to support. VSTO 3.0 supports the creation of
document-oriented approaches for InfoPath, Word, and Excel. Essentially,
document-oriented approaches provide a document pointing to very specific
tasks. An example of a document-oriented approach would be where uniform
template kind of documents are managed inside a team or company without
affecting the application of the document that they reside in.