Jak to zrobić w 2007 Office System

Na stronach MSDN publikowane są przykłady (tzw. How-To) pokazujące jak wykonać pewne czynności programistyczne związane z dodawaniem nowych funcjonalności do pakietu Office System 2007 oraz WSS 3.0. Wiele z tych przykladów to tzw. Video How-To czyli przyklady gdzie opisowi i fragmentom kodu towarzyszy film video. Jest to według mnie chyba najszybsza metoda nauki. Poniżej zamieszczam listę materiałów dostępnych w MSDN i życzę owocnej nauki Office Fluent Ribbon

• Add Custom Buttons to the 2007 Office Fluent Ribbon
• Add Custom Check Boxes to the 2007 Office Fluent Ribbon
• Add Custom Combo Boxes to the 2007 Office Fluent Ribbon
• Add Custom DialogBoxLauncher Controls to the 2007 Office Fluent User Interface
• Add Custom Dynamic Menus to the Office Fluent User Interface
• Add Tabs and Controls to the Office Fluent Ribbon in Access 2007
• Customize the Office Fluent Ribbon in Visual Studio 2005 Tools for Office Second Edition
• Hide Groups on the Office Fluent Ribbon Using a Toggle Button
• Hide Tabs on the Office Fluent Ribbon Using a Toggle Button
• Map Word 2007 Content Controls to Custom XML Using the XMLMapping Object
• Programmatically Customize the 2007 Office Fluent User Interface
• Temporarily Repurpose Commands on the Office Fluent Ribbon

XML in the 2007 Office System

• Build Word 2007 Documents Using the Office Open XML Formats
• Map Word 2007 Content Controls to Custom XML Using the XMLMapping Object
• Office Open XML Formats: Inserting Values into Excel 2007 Cells
• Office Open XML Formats: Replace PowerPoint 2007 Slide Images
• Office Open XML Formats: Retrieve Excel 2007 Cell Values
• Office Open XML Formats: Retrieve Lists of Excel 2007 Worksheets
• Office Open XML Formats: Retrieve Lists of PowerPoint 2007 Slides
• Office Open XML Formats: Set Custom Word 2007 Document Properties

Access 2007

• Add (All) Options to Combo Boxes or List Boxes in Access 2007
• Add Tabs and Controls to the Office Fluent Ribbon in Access 2007
• Create User Prompts in Access 2007
• Display Custom Dialog Boxes for Custom Delete Actions in Access 2007
• Synchronize Combo Boxes on Forms in Access 2007

Excel 2007

• Add Chart Elements to Charts in Excel 2007
• Bind Data to User Controls in Excel Using Visual Studio 2005 Tools for Office SE
• Create Basic Column Charts in Excel 2007
• Create Calculated Columns in Excel 2007
• Create Managed-Code UDFs for Excel Services
• Insert Values into Excel 2007 Cells (Office Open XML Formats)
• Retrieve Excel 2007 Cell Values (Office Open XML Formats)
• Retrieve Excel 2007 Workbooks or Snapshots Using SharePoint Server 2007 Excel Services
• Retrieve Lists of Excel 2007 Worksheets (Office Open XML Formats)
• Save Workbooks to PDF and XPS Formats in Excel 2007
• Set Conditional Formatting in Excel 2007

InfoPath 2007

• Build Simple Custom Approval Workflows with InfoPath 2007 Forms
• Create and Edit Custom Document Information Panels from InfoPath 2007
• Use Business Data Catalog Actions to Pass Parameters to InfoPath 2007 Browser Forms

Outlook 2007

• Search the Outlook 2007 Inbox for Items with Subjects Containing Specific Words

PowerPoint 2007

• Replace PowerPoint 2007 Slide Images (Office Open XML Formats)
• Retrieve Lists of PowerPoint 2007 Slides (Office Open XML Formats)
• Use Visual Studio 2005 Tools for Office SE to Create Add-Ins with Custom Task Panes in PowerPoint 2007
• Use Visual Studio 2005 Tools for Office SE to Create PowerPoint Add-Ins

SharePoint Designer 2007

• Build Custom Activities for Use in SharePoint Designer 2007
• Build Simple Master Pages for Windows SharePoint Services 3.0
• Expose Enterprise Search in SharePoint Server 2007 Using Internet Explorer 7 and the Office Research Pane

SharePoint Server 2007

• Build Simple Custom Approval Workflows with InfoPath 2007 Forms
• Build Simple Master Pages for Windows SharePoint Services 3.0
• Create a Custom Search Page and Tabs in the Search Center of SharePoint Server
• Create and Edit Custom Document Information Panels from SharePoint Server 2007
• Create and Expose Managed Properties in the Advanced Search Page of SharePoint Server Enterprise Search
• Create and Expose Search Scopes in SharePoint Server 2007 Enterprise Search
• Create Business Data Catalog Entities in SharePoint Server 2007
• Create Content Sources to Crawl Business Data in SharePoint Server 2007 Enterprise Search
• Create Managed-Code UDFs for Excel Services
• Create Search Queries Programmatically Using the Search Object Model in SharePoint Server 2007
• Create Search Queries Programmatically Using the Search Web Service in SharePoint Server 2007
• Enable Users to Act on LOB Data with Business Data Catalog Actions
• Expose Enterprise Search in SharePoint Server 2007 Using Internet Explorer 7 and the Office Research Pane
• Filter One Business Data Catalog List from Another by Using Associations in SharePoint Server 2007
• Refine Business Data Catalog Search with Scopes
• Retrieve Excel 2007 Workbooks or Snapshots Using SharePoint Server 2007 Excel Services
• Use Business Data Catalog Actions to Pass Parameters to InfoPath 2007 Browser Forms

Visual Studio 2005 Tools for Office Second Edition

• Automate a Word 2007 Document Using Visual Studio 2005 Tools for Office SE Ribbon Support
• Bind Data to User Controls in Excel Using Visual Studio 2005 Tools for Office SE
• Create Outlook Form Regions by Using Visual Studio 2005 Tools for Office SE
• Customize the Office Fluent Ribbon in Visual Studio 2005 Tools for Office Second Edition
• Search the Outlook 2007 Inbox for Items with Subjects Containing Specific Words
• Troubleshoot Deployment Errors in Visual Studio 2005 Tools for Office SE
• Use Visual Studio 2005 Tools for Office SE to Create Add-Ins with Custom Task Panes in PowerPoint 2007
• Use Visual Studio 2005 Tools for Office SE to Create PowerPoint Add-Ins

Windows SharePoint Services 3.0

• Activate Auditing Programmatically for a Single Document Library in Windows SharePoint Services 3.0
• Activate Auditing Programmatically for a Site Collection in Windows SharePoint Services 3.0
• Build Custom Activities for Use in SharePoint Designer 2007
• Build Custom Field Types in Windows SharePoint Services 3.0
• Configure IntelliSense with CAML Files When Developing for Windows SharePoint Services 3.0
• Create a Custom HttpHandler (AuditLogWorkbook.ashx) in in Windows SharePoint Services 3.0
• Create a Feature for an Entry Control Block Item in Windows SharePoint Services 3.0
• Create a Feature for the Site Actions Menu in Windows SharePoint Services 3.0
• Create an Application Page in Windows SharePoint Services 3.0
• Create a Solution Package in in Windows SharePoint Services 3.0
• Display Data by Using the SPGridView Control in Windows SharePoint Services 3.0
• Read Entries from the Audit Log in Windows SharePoint Services 3.0
• Read ListId and ItemId from an Application Page in Windows SharePoint Services 3.0
• Run Commands with Elevated Privileges in Windows SharePoint Services 3.0
• Write Custom Entries to the Audit Log in Windows SharePoint Services 3.0
• Write a Filter Consumer Web Part for Windows SharePoint Services 3.0 Using Excel Services
• Write a Filter Provider Web Part for Windows SharePoint Services 3.0

Word 2007

• Automate a Word 2007 Document Using Visual Studio 2005 Tools for Office SE Ribbon Support
• Build Word 2007 Document Templates Using Content Controls
• Build Word 2007 Documents Using the Office Open XML Formats
• Change the Type of a Word 2007 Content Control
• Create a Custom Building Block Gallery in Word 2007
• Filter the Building Block List in a Word 2007 Content Control
• Insert a Word 2007 Content Control into a Building Block
• Map Word 2007 Content Controls to Custom XML Using the XMLMapping Object
• Retrieve Custom Building Blocks from Templates in Word 2007
• Run Commands When Inserting Building Blocks into Word 2007 Documents
• Save Ranges as Custom Building Blocks in Word 2007 Documents
• Save Word 2007 Documents to PDF and XPS Formats
• Set Custom Word 2007 Document Properties (Office Open XML Formats)

	Łukasz Skłodowski - więcej informacji Architekt rozwiązań SharePoint oraz kierownik projektów z ponad 10-letnim doświadczeniem. Właściciel firmy Mavsystem i autor bloga officesystem.pl