Microsoft Office 2003 Editions: Overview of Developer TechnologiesSeptember 2004
Follow a basic walk-through using custom XML with Excel:
Learn how Excel makes importing data easier with XML:
Read a technical article on the new Excel XML features:
Learn how to import and export data using schemas with Access 2003:
Read one way to transfer XML data from Access 2003 to Excel 2003:
Learn how XML standards are used in InfoPath 2003:
A smart document is a document-based solution which provides a user with help information, auxiliary data, available actions and custom tools that are pertinent to where a user is working in the document. These items are presented dynamically when a user enters that region of the document. With this type of solution, it is easier for someone to work with the document because the solution can guide them and provide supporting information. Smart document solutions are supported in Word 2003 and Excel 2003. Smart document solutions build off the custom XML schema capabilities in those products. Figure 4 shows a smart document solution using Excel with task-specific guidance and tools that help perform a budgetary analysis through the right-hand task pane. Smart document scenarios can include such varying tasks as streamlining a financial analysis or numerical aggregation in Excel, or managing a sales proposal or a legal compliance form in Word.
Figure 4. Smart document solution in Excel
Smart Document Benefits
Users become more productive with smart documents because content is presented in the task pane as they navigate through a document, reducing the time spent searching for or filling in data, or looking for help. At the same time, users continue to enjoy the familiarity of working with Word and Excel.
You can enable this enhanced UI through a programmable task pane that can contain any variation of data, help, and common controls— such as buttons, check boxes, option buttons, and list boxes— hyperlinks, images, free text, and more. This allows you to create solutions that offer a richer UI, provide content that is relevant to the specific task a user needs to perform
© 2006 Microsoft Corporation. All rights reserved. Page 12 By using or providing feedback on these materials, you agree to the attached license agreement.
To comment on this paper or request more documentation on these developer features, contact us at . We look forward to hearing from you.