microsoft ®.net and microsoft ® office 2003 suthep sangvirotjanaphat [mvp]

MicrosoftMicrosoft®® .NET and .NET and MicrosoftMicrosoft®® Office 2003 Office 2003

Suthep Suthep Sangvirotjanaphat Sangvirotjanaphat [MVP][MVP]www.GreatFriends.Bizwww.GreatFriends.Biz

What We Will CoverWhat We Will Cover

XML capabilities in MicrosoftXML capabilities in Microsoft®® Excel Excel 2003 and Microsoft2003 and Microsoft® ® Word 2003Word 2003

New Smart Tag features in Office 2003New Smart Tag features in Office 2003 MicrosoftMicrosoft®® Visual Studio Tools for the Visual Studio Tools for the

Microsoft Office System (Visual Studio Microsoft Office System (Visual Studio Tools for Office)Tools for Office)

Session PrerequisitesSession Prerequisites

Level 200Level 200

Experience programming in the .NET FrameworkExperience programming in the .NET Framework Familiarity with XMLFamiliarity with XML Exposure to Office applicationsExposure to Office applications

So Why This Presentation?So Why This Presentation? To introduce Office 2003 and MicrosoftTo introduce Office 2003 and Microsoft® ® Visual StudioVisual Studio®® .NET 2003 .NET 2003 To show why the new features in Office 2003 allow for a stronger development modelTo show why the new features in Office 2003 allow for a stronger development model To demonstrate how Visual Studio .NET can assist in Office 2003 developmentTo demonstrate how Visual Studio .NET can assist in Office 2003 development

DemonstrationsDemonstrations

Applying XML in Excel 2003 and Word Applying XML in Excel 2003 and Word 20032003

Smart Tags in Office 2003Smart Tags in Office 2003 Using Web services in Excel 2003Using Web services in Excel 2003

AgendaAgenda

What’s new in Office developmentWhat’s new in Office development XML supportXML support Smart TagsSmart Tags Smart DocumentsSmart Documents Visual Studio Tools for Office Visual Studio Tools for Office

What’s New in Office What’s New in Office DevelopmentDevelopmentWhat Hasn’t ChangedWhat Hasn’t Changed

MicrosoftMicrosoft®® Visual Basic Visual Basic®® for for Applications language is still hereApplications language is still here

What’s New in Office What’s New in Office DevelopmentDevelopmentWhat Has ChangedWhat Has Changed

Smart Tags version 2Smart Tags version 2 ListsLists Shared workspacesShared workspaces Web servicesWeb services PIAsPIAs


XML support for Word and Excel XML support for Word and Excel


Visual Studio Tools for Office add-in to Visual Studio Tools for Office add-in to Visual Studio .NET 2003 Visual Studio .NET 2003

AgendaAgenda

What’s new in Office developmentWhat’s new in Office development XML support XML support Smart TagsSmart Tags Smart DocumentsSmart Documents Visual Studio Tools for Office Visual Studio Tools for Office

XML SupportXML SupportWord 2003 Word 2003

XML support in Word 2003XML support in Word 2003 Separation of dataSeparation of data Native XML file formatNative XML file format Smart clientsSmart clients

XML SupportXML SupportXML Schemas in Word 2003XML Schemas in Word 2003

XML schemas and what they doXML schemas and what they do Customer-defined schemasCustomer-defined schemas Task paneTask pane

XML SupportXML SupportXML Schemas in Excel 2003XML Schemas in Excel 2003

XML schemas differences in Excel 2003XML schemas differences in Excel 2003 Mapping elements to your spreadsheetMapping elements to your spreadsheet ““XML Structure” task paneXML Structure” task pane Using multiple Using multiple

schemasschemas

XML SupportXML SupportWord 2003 Style SheetsWord 2003 Style Sheets

XSL style sheets automation and XSL style sheets automation and manual usemanual use

XML SupportXML SupportExcel 2003 Mapping ToolExcel 2003 Mapping Tool

The Mapping Tool paneThe Mapping Tool pane What can it do?What can it do? Up-to-the-minute dataUp-to-the-minute data

XML SupportXML SupportExcel 2003 ListsExcel 2003 Lists

What is a list?What is a list? Other Office tools that uses listsOther Office tools that uses lists Lists object model Lists object model

XML SupportXML SupportOpening and Saving Opening and Saving

Saving XML data in Word 2003Saving XML data in Word 2003 Opening XML data in Word 2003Opening XML data in Word 2003 Saving XML data in Excel 2003Saving XML data in Excel 2003 Opening XML data in Excel 2003Opening XML data in Excel 2003

Demonstration 1Demonstration 1Using XML in Excel 2003 and Using XML in Excel 2003 and

Word 2003Word 2003

AgendaAgenda

What’s new in Office developmentWhat’s new in Office development XML supportXML support Smart TagsSmart Tags Smart DocumentsSmart Documents Visual Studio Tools for Office Visual Studio Tools for Office

Smart TagsSmart TagsSmart Tag Basics Smart Tag Basics Smart TagsSmart Tags

Recognize specific text in a documentRecognize specific text in a document Actions are offered on recognized textActions are offered on recognized text

Works in Word, Excel, MicrosoftWorks in Word, Excel, Microsoft® ®

PowerPointPowerPoint®®, Microsoft, Microsoft® ® Access, MicrosoftAccess, Microsoft® ®

OutlookOutlook®®, and Internet Explorer, and Internet Explorer Pre-built Smart TagsPre-built Smart Tags

Smart TagsSmart TagsWhat Can a Smart Tag Do? What Can a Smart Tag Do?

Smart TagsSmart TagsSmart Tag Types Smart Tag Types

Definition of a Smart Tag typeDefinition of a Smart Tag type ““urn:schema-microsoft-urn:schema-microsoft-

com:person#address”com:person#address” URI = “schema-microsoft-com”URI = “schema-microsoft-com” Local property name = “person”Local property name = “person” Tag name = “address”Tag name = “address”

ISmartTagRecognizer2 and ISmartTagRecognizer2 and ISmartTagAction2 interfacesISmartTagAction2 interfaces

Smart TagsSmart TagsSmart Tag CustomizationSmart Tag Customization

The recognizerThe recognizer Defines Smart Tags in a documentDefines Smart Tags in a document

The actions The actions Associate the correct actions to a Smart Associate the correct actions to a Smart

Tag typeTag type

Smart TagsSmart TagsWhat Has Changed for Office 2003?What Has Changed for Office 2003? New features for Smart Tags New features for Smart Tags

Available for Word, Excel, Outlook, PowerPoint, Available for Word, Excel, Outlook, PowerPoint, Access, and Internet ExplorerAccess, and Internet Explorer

Recognizers trigger actions on recognitionRecognizers trigger actions on recognition Smart Tags reload without restartingSmart Tags reload without restarting Dynamic Smart Tag menusDynamic Smart Tag menus Cascading menusCascading menus Tokenizer built-in to recognizerTokenizer built-in to recognizer Regular expressions in MOSTLRegular expressions in MOSTL New Smart Tag typesNew Smart Tag types

ExpiringExpiring UnsavableUnsavable FragileFragile

Demonstration 2Demonstration 2Creating a Smart TagCreating a Smart Tag

AgendaAgenda

What’s new in Office developmentWhat’s new in Office development XML support XML support Smart TagsSmart Tags Smart DocumentsSmart Documents Visual Studio Tools for Office Visual Studio Tools for Office

Smart DocumentsSmart Documents

Dynamic content based on the user’s Dynamic content based on the user’s actionsactions

Examples of what Smart Documents Examples of what Smart Documents can docan do

Dynamic task panesDynamic task panes Common controlsCommon controls Dynamic data from other sourcesDynamic data from other sources Context-sensitive helpContext-sensitive help


Distributing Smart DocumentsDistributing Smart Documents Updating existing Smart Document Updating existing Smart Document

solutionssolutions Smart Documents security modelSmart Documents security model


Example of a Smart Document in actionExample of a Smart Document in action

Employee Manager

Network / Web server


Smart Documents must be based on an Smart Documents must be based on an XML schemaXML schema

Create a DLL to interact with the Smart Create a DLL to interact with the Smart DocumentDocument

Create a reference to the MicrosoftCreate a reference to the Microsoft®® Smart Tags 2.0 Type LibrarySmart Tags 2.0 Type Library

Must implement the ISmartDocument Must implement the ISmartDocument interfaceinterface

Microsoft Office Smart Documents SDKMicrosoft Office Smart Documents SDK

AgendaAgenda

What’s new in Office developmentWhat’s new in Office development XML supportXML support Smart TagsSmart Tags Smart DocumentsSmart Documents Visual Studio Tools for OfficeVisual Studio Tools for Office

Visual Studio Tools for Visual Studio Tools for OfficeOffice Use .NET-managed code to developUse .NET-managed code to develop Create Word 2003 and Excel 2003 Create Word 2003 and Excel 2003

projectsprojects Create a reference to the Microsoft Create a reference to the Microsoft

Smart Tags 2.0 Type LibrarySmart Tags 2.0 Type Library Use the Visual Studio .NET 2003 IDEUse the Visual Studio .NET 2003 IDE All the benefits of the .NET Framework All the benefits of the .NET Framework

class libraryclass library

Visual Studio Tools for Visual Studio Tools for OfficeOffice The Visual Studio Tools for Office architecture modelThe Visual Studio Tools for Office architecture model

Visual Studio Tools for Visual Studio Tools for OfficeOffice Visual Studio .NET 2003 projects for Visual Studio .NET 2003 projects for

Office 2003Office 2003 Word Document projectWord Document project Word Template projectWord Template project Excel Workbook projectExcel Workbook project

Projects available in Visual Basic .NET Projects available in Visual Basic .NET or Microsoftor Microsoft®® Visual C# Visual C#®®

Demonstration 3Demonstration 3Using Visual Studio Using Visual Studio

Tools for OfficeTools for Office

Session SummarySession Summary

Office 2003 XML featuresOffice 2003 XML features Smart Tags in Office 2003Smart Tags in Office 2003 The new Smart DocumentsThe new Smart Documents Visual Studio Tools for OfficeVisual Studio Tools for Office

For More Information…For More Information…

MSDN Web site at MSDN Web site at msdn.microsoft.commsdn.microsoft.com

Training & Training & EventsEvents

MSDN Webcasts, MSDN Online MSDN Webcasts, MSDN Online Seminars, Tech·Ed, PDC, Developer DaysSeminars, Tech·Ed, PDC, Developer Days

MSDNMSDNEssential Resources for DevelopersEssential Resources for Developers

Subscription Subscription ServicesServices

OnlineOnlineInformationInformation

MembershipMembershipProgramsPrograms

Print Print PublicationsPublications

Library, OS, Professional, Enterprise, Library, OS, Professional, Enterprise, Universal Delivered via CD-ROM, DVD, WebUniversal Delivered via CD-ROM, DVD, Web

MSDN Online, MSDN Flash, How-to MSDN Online, MSDN Flash, How-to Resources, Download CenterResources, Download Center

MSDN User GroupsMSDN User Groups

MSDN MagazineMSDN MagazineMSDN NewsMSDN News

How-to ResourcesHow-to ResourcesSimple, Step-by-Step ProceduresSimple, Step-by-Step Procedures Embedded development How-to resourcesEmbedded development How-to resources General How-to resources General How-to resources Integration How-to resources Integration How-to resources MicrosoftMicrosoft®® JScript JScript®® .NET How-to resources .NET How-to resources Microsoft .NET development How-to resources Microsoft .NET development How-to resources Office development resources Office development resources Security How-to resources Security How-to resources Visual Basic .NET How-to resources Visual Basic .NET How-to resources Visual C# .NET How-to resources Visual C# .NET How-to resources Visual Studio .NET How-to resources Visual Studio .NET How-to resources Web development How-to resources (ASP, IIS, XML) Web development How-to resources (ASP, IIS, XML) Web services How-to resources Web services How-to resources Windows development How-to resources Windows development How-to resources

http://msdn.microsoft.com/howtohttp://msdn.microsoft.com/howto

MSDN WebcastsMSDN WebcastsInteractive, Live Online EventsInteractive, Live Online Events

Interactive, synchronous, live online Interactive, synchronous, live online eventsevents

Discuss the hottest topics from MicrosoftDiscuss the hottest topics from Microsoft Open and free for the general publicOpen and free for the general public Take place every TuesdayTake place every Tuesday

http://www.microsoft.com/usa/webcastshttp://www.microsoft.com/usa/webcasts

MSDN Subscriptions MSDN Subscriptions TheThe Way to Get Visual Studio .NET Way to Get Visual Studio .NETVisual Studio .NETVisual Studio .NET MSDN SubscriptionsMSDN Subscriptions

NE

W

ProfessionalProfessional• Tools to build applications Tools to build applications

and XML Web services for and XML Web services for Windows and the WebWindows and the Web

MSDN ProfessionalMSDN Professional$1199 new$1199 new

$899 renewal/upgrade$899 renewal/upgrade

MSDN EnterpriseMSDN Enterprise$2199 new$2199 new


MSDN UniversalMSDN Universal$2799 new$2799 new


Enterprise DeveloperEnterprise Developer• Enterprise lifecycle toolsEnterprise lifecycle tools• Team development supportTeam development support•Windows Server 2003 and Windows Server 2003 and

SQL Server™SQL Server™

Enterprise ArchitectEnterprise Architect• Software and data modelingSoftware and data modeling• Enterprise templatesEnterprise templates• Architectural guidanceArchitectural guidance

Where Can I Get MSDN?Where Can I Get MSDN?

Visit MSDN Online atVisit MSDN Online atmsdn.microsoft.commsdn.microsoft.com

Register for the MSDN Flash e-mail Register for the MSDN Flash e-mail newsletter at newsletter at msdn.microsoft.com/flashmsdn.microsoft.com/flash

Become an MSDN CD subscriber at Become an MSDN CD subscriber at msdn.microsoft.com/subscriptionsmsdn.microsoft.com/subscriptions

MSDN online seminarsMSDN online seminarsmsdn.microsoft.com/training/seminarsmsdn.microsoft.com/training/seminars

Attend more MSDN eventsAttend more MSDN events

Microsoft PressMicrosoft Press®®

Essential Resources for DevelopersEssential Resources for Developers

Microsoft Visual Studio .NET is here!Microsoft Visual Studio .NET is here!This is your chance to start building the next big This is your chance to start building the next big

thing. Develop your .NET skills, increase your thing. Develop your .NET skills, increase your productivity with .NET books from Microsoft Pressproductivity with .NET books from Microsoft Press

www.microsoft.com/mspresswww.microsoft.com/mspress

Become a Microsoft Certified Become a Microsoft Certified Solution DeveloperSolution Developer

What is MCSD?What is MCSD? Premium certification for professionals who design Premium certification for professionals who design

and develop custom business solutionsand develop custom business solutions How do I attain MCSD certification?How do I attain MCSD certification?

Certification requires passing four exams to prove Certification requires passing four exams to prove competency with Microsoft solution architecture, competency with Microsoft solution architecture, desktop applications, distributed application desktop applications, distributed application development, and development toolsdevelopment, and development tools

Where do I get more information?Where do I get more information? For more information about certification For more information about certification

requirements, exams, and training options, requirements, exams, and training options, visit visit www.microsoft.com/mcpwww.microsoft.com/mcp

© 2003 Microsoft Corporation. All rights reserved.© 2003 Microsoft Corporation. All rights reserved.This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.

Microsoft, Windows, JScript .NET, Visual C#, Visual C++, Visual Basic, Visual Studio, MSDN, PowerPoint, SharePoint, Outlook, IntelliSense, and Microsoft Press are either Microsoft, Windows, JScript .NET, Visual C#, Visual C++, Visual Basic, Visual Studio, MSDN, PowerPoint, SharePoint, Outlook, IntelliSense, and Microsoft Press are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries. The names of actual companies and products mentioned herein registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries. The names of actual companies and products mentioned herein

may be the trademarks of their respective owners.may be the trademarks of their respective owners.