Building Solutions with the Microsoft Office System

1
Building Solutions with the Microsoft Office
System
2
Building Solutions with the Microsoft Office
System
Don Campbell Business Productivity Tech
Spec Healthcare Life Sciences Microsoft
Corporation
3
Agenda

• Microsoft Office System
• XML in Office 2003
• Whats new for Developers in Office 2003?
• Demos
• Where to go for more

4
Information Worker

• Serve a broader customer audience

• Create new customer value through innovation

• Help customers realize business value

5
Microsoft Office System

• Office System brand

Office box
Client, server, and services system
Client suite
Personal, team, and organization productivity
Personal productivity
6
The Microsoft Office System
7
Productivity Architecture
Tools
Services
8
Automating Information

• With Microsoft Office System
• Information shared across org
• Improved efficiency
• Accurate, valid information

Physicians, Nurses,
Document Exchange
HL7 CDA XML
XML Web Services
HL7 CDA XML
Presentationon MultipleDevices
BusinessProcesses
Collaboration
Transcription
9
The Promise Of XML

• Sharing data is hard
• Numerous implementations, binary, and text
• Many storage mechanisms
• Differing structures and definitions
• XML makes it easy
• A standardized approach to describing and
  structuring data

10
XML Meets The Office System

• Sharing data with/from Microsoft Office
• Numerous file formats and versions
• .doc, .xls, .mdb, .vsd, .txt, .csv, .rtf, .htm,
  etc.
• Commonly require coded solutions
• Resulted in usable data being locked in documents
  or unavailable for use within Office
• XML makes this easy too

11
Why? XML In The Office System?

• Allows data to be freely introduced to, and
  provided from Office applications without regards
  to structure, format, or proprietary
  requirements.
• Simply stated
• XML simplifies common data exchange

12
XML in Microsoft Office 2003

• Data Analysis
• Tabular, largely numerical data for calculations
  and analysis
• Data best presented in a grid

• Reporting Storing
• Numerical or textual fields
• Relational tables in databases

• Content Authoring
• Large areas of text or mixed content
• Flexible layout and formatting with XML markup

• Data Driven Web Sites
• Tabular or hierarchical data inserted into web
  pages
• Expanded data reach

• Information Gathering
• Highly structured, grouped information
• Form-like with few paragraphs of formatted text

13
XML In The Office System 2003

• Create documents in native XML file formats
• Save documents as XML
• Work with data in your own format
• Built-in support for customer-defined schemas
• Use industry standard XSD to provide structure to
  documents
• Repurpose Office documents
• Leverage XML technologies such as XPath and XSLT
  to unlock data previously captured in binary
  formats
• Connect to business systems and processes
• Import/Export data only as XML
• Produce Office documents without the executables
• Create server-side applications that generate
  Office documents

14
XML Terminology Primer/Review

• XML
• eXtensible Markup Language
• Markup language for documents containing
  structured information
• XSD
• XML Schema Definition Language
• XML language for describing and constraining the
  content of XML documents
• XSLT
• eXtensible Stylesheet Language Transformations
• Language for transforming XML documents into
  other XML documents
• XPath
• XML Path Language
• Language for addressing parts of an XML document

15
New Technologies in Office

• Word and Excel XML Support
• Smart Documents
• Expanded Smart Tags
• VS Tools for Office
• Research Library
• InfoPath
• Web Services Smart Client
• Windows SharePoint Services

16
XML in Word and Excel

• Expanded XML support in Word 2003 and Excel 2003,
  including object model programmability and the
  use of customer-defined XML schemas

Creating an End-to-End XML Solution with Word
2003 and Excel 2003 http//msdn.microsoft.com/lib
rary/default.asp?url/library/en-us/dnofftalk/html
/office04032003.asp
17
Smart Documents

• A new Office 2003 solutions model called smart
  documents
• Use underlying XML Schema
• Custom DLL (managed code)
• Enable context sensitive actions in the document
• Full security
• Automatic updates

Smart Documents Development Overview http//msdn.m
icrosoft.com/library/default.asp?url/library/en-u
s/odc_wd2003_ta/html/odc_smartdocovw.asp
18
Smart Documents
Smart Documents Development Overview http//msdn.m
icrosoft.com/library/default.asp?url/library/en-u
s/odc_wd2003_ta/html/odc_smartdocovw.asp
19
Smart Documents
20
Expanded Smart Tags

• Now available in Access and PowerPoint as well as
  Word, Excel and Outlook.
• Execute actions immediately upon recognition
• Modify current
• Dynamic captions
• Cascading menus
• Expiration

Whats New with Smart Tags in Office
2003? http//msdn.microsoft.com/library/default.as
p?url/library/en-us/dnofftalk/html/office01022003
.asp
21
Visual Studio Tools for Office

• Word and Excel project templates in Visual Studio
  .NET
• Build and debug Word and Excel solutions in
  Visual Studio .NET

Visual Studio Tools for Office 2003 http//msdn.mi
crosoft.com/vstudio/office/
22
Visual Studio Tools for Office

• And now. InfoPath

23
Visual Studio Tools for Office
24
Microsoft InfoPath

• XML data collection
• Conditional formatting
• No coding required
• Effective sharing
• Any schema
• XML Web services
• Data management
• Dynamic forms
• Text formatting, AutoCorrect
• Offline and e-mail

25
Windows SharePoint Services

• Document and Meeting Workspaces in Word, Excel,
  PowerPoint
• Objects and Collections to programmatically
  update workspaces
• InfoPath Forms Libraries easily created without
  programming

26
Research Library

• One click lookup in Office Applications
• Simple Web Service Interface
• Smart Tags Support
• Add New Research Services Online
• Partner Solutions at Launch

Research and Reference in Office
2003 http//www.microsoft.com/technet/treeview/def
ault.asp?url/technet/prodtechnol/office/Office200
3/Plan/SmrtDcSy.asp
27
Research Library
Research and Reference in Office
2003 http//www.microsoft.com/technet/treeview/def
ault.asp?url/technet/prodtechnol/office/Office200
3/Plan/SmrtDcSy.asp
28
(No Transcript)
29
(No Transcript)
30
(No Transcript)
31
Building Research Services

• Create server-side Web service with two methods
• Registration Web Method
• Configures Office client to use service
• string Registration (string registrationXml)
• Query Web Method
• Accepts searches and provides responses to Office
  clients
• string Query (string queryXml)
• Communication is defined by a number of XSD
  schemas

32
Service Deployment Options

• Add service from Office user interface
• Via URL in Research Options
• Setup .exe to write registry keys
• Admin roll out with Office image
• Implement a corporate discovery service
• Enables auto installation and/or advertisement of
  Research Services

33
Partner Momentum
34
Additional Resources

• Microsoft Office 2003 - MSDN
• http//msdn.microsoft.com/office

Office Zealot http//officezealot.com
35
Call To Action

• Try Office 2003 and Visual Studio Tools for
  Office
• Visit http//msdn.microsoft.com/office

Don Campbell Business Productivity Technology
Specialist Microsoft Corporation donca_at_microsoft.c
om
36
Questions?