MSDN: Microsoft Office Developer Center - How Do I

Adding Images to Documents in Word 2007 by Using the Open XML SDK 2.0 for Microsoft Office (Visual How To)

Tue, 04 Aug 2009 00:00:00 GMT

Watch the video and explore sample code as you learn how to create Word 2007 documents that contain inline and floating images.

Building String References with Embedded Quotes in Access 2007 (Visual How To)

Tue, 04 Aug 2009 00:00:00 GMT

Watch the video and explore sample code as you learn a simple way to build a WHERE clause in code that contains embedded quotes in strings.

Embedding Documents in Word 2007 by Using the Open XML SDK 2.0 (Visual How To)

Tue, 04 Aug 2009 00:00:00 GMT

Watch the video and explore sample code as you learn how to embed a Word 2007 document programmatically into another Word 2007 document.

Generating Documents with Headers and Footers in Word 2007 by Using the Open XML SDK 2.0 for Microsoft Office (Visual How To)

Tue, 04 Aug 2009 00:00:00 GMT

Watch the video and explore sample code as you learn to programmatically create Word 2007 documents that contain headers and footers.

Choosing Output Devices at Runtime in Access 2007 (Visual How To)

Tue, 28 Jul 2009 00:00:00 GMT

Watch the video and download the sample code as you learn how to select an output device for a report at runtime in Access 2007 by using the built-in Printer object.

Creating a Master Detail View in Excel 2007 (Visual How To)

Tue, 21 Jul 2009 00:00:00 GMT

Watch the video and download the sample code as you learn to use structured references programmatically to implement a master-detail view in Excel 2007.

Adding Contacts and Sending E-mail in Access 2007 by Using Outlook 2007 (Visual How To)

Tue, 14 Jul 2009 00:00:00 GMT

Watch the video and download the sample code as you learn to use Automation to create Outlook 2007 contacts from a contact list in Access 2007, and then send Outlook 2007 e-mail from within Access.

Using LINQ to Query Tables in Excel 2007 (Visual How To)

Tue, 23 Jun 2009 00:00:00 GMT

Learn how to use the Open XML Formats to load information stored in Excel worksheets into generic lists that support LINQ.

Changing and Resetting the Caption Bar in Access 2007 (Visual How To)

Tue, 09 Jun 2009 00:00:00 GMT

Learn a simple way to retrieve, modify, and reset the text that is in the Access 2007 title bar.

Uploading Files to SharePoint Server 2007 from ASP.NET Web Applications by Using the HTTP PUT Method (Visual How To)

Wed, 03 Jun 2009 00:00:00 GMT

Learn how to use the HTTP PUT method to programmatically upload files from an ASP.NET Web application to a SharePoint Server 2007 site.

Creating Auto-Filtered Tables in Excel 2007 (Visual How To)

Tue, 02 Jun 2009 00:00:00 GMT

Learn how to programmatically add a filter to a column of table data in Excel 2007.

Programmatically Adding Items to Lists or Combo Boxes in Access 2007 (Visual How To)

Tue, 02 Jun 2009 00:00:00 GMT

Learn several different ways to fill a list box or a combo box in Access 2007 programmatically.

Consuming Web Services in Excel 2007 (Visual How To)

Thu, 28 May 2009 00:00:00 GMT

Learn how to call the Live Search Web service from an Excel 2007 document-level customization and insert search results into a worksheet.

Creating PivotTables In Excel 2007 (Visual How To)

Thu, 28 May 2009 00:00:00 GMT

Learn how to programmatically add a PivotTable to an Excel 2007 worksheet.

Finding the Median Value for Fields in Access 2007 (Visual How To)

Tue, 12 May 2009 00:00:00 GMT

Learn how to calculate the median value in Access 2007 fields by importing a custom module that contains a DMedian function.

Creating Simple Bar Graphs in Reports in Access 2007 (Visual How To)

Tue, 12 May 2009 00:00:00 GMT

Learn how to create a report that uses a bar graph to represent numerical values. The solution requires very little effort and does not use any external controls.

Using the VLookup Function in Excel 2007 (Visual How To)

Tue, 05 May 2009 00:00:00 GMT

Learn how to dynamically search table arrays in Excel 2007 using the built-in VLOOKUP function.

Customizing the Groove 2007 Forms Tool to Create Simple Status Reports (Visual How To)

Tue, 05 May 2009 00:00:00 GMT

Create a custom tool where team contributors can cite the weekly status of their project deliverables.

Running and Pausing Other Applications from Access 2007 (Visual How To)

Tue, 28 Apr 2009 00:00:00 GMT

Learn how to run an external application from within Access 2007 and then prevent Access 2007 from continuing until that external application completes its task.

Using Excel 2007 Functions in Access 2007 (Visual How To)

Tue, 28 Apr 2009 00:00:00 GMT

Learn how to call Excel 2007 functions from Access 2007 by using Automation, and to insert data into Office Excel 2007 sheets or pass arrays of data as parameters.

Coding Groove Web Services Applications with the Groove 2007 SDK, Part 1 (Visual How To)

Wed, 22 Apr 2009 00:00:00 GMT

Learn to develop Groove Web Services (GWS) applications using the Groove 2007 SDK and CodePlex GWS Helpers Library.

Coding Groove Web Services Applications with the Groove 2007 SDK, Part 2 (Visual How To)

Tue, 21 Apr 2009 00:00:00 GMT

Learn how using the CodePlex GWS Helper library can reduce the complexity of your application in comparison to using the Groove SDK without the Helper library.

Using Variables in VBA to Filter Access 2007 Queries (Visual How To)

Wed, 08 Apr 2009 00:00:00 GMT

Learn to filter the results of an Access 2007 query by using a fixed expression, a built-in VBA function, or a VBA variable of a custom function.

Creating Page-Range Indicators on Pages in Access 2007 (Visual How To)

Wed, 08 Apr 2009 00:00:00 GMT

Add some hidden text in the page header of the report and a little bit of VBA code to display the first and last items on the page, similar to a telephone book.

Creating Combo Boxes in Access 2007 that Allows Users to Select N/A (Visual How To)

Wed, 08 Apr 2009 00:00:00 GMT

The solution uses a simple Union query and an unbound combo box where users cannot enter any invalid entries, just a provided value or a special string such as "N/A".

Highlighting the Current Field in Data Entry Forms in Access 2007 (Visual How To)

Wed, 08 Apr 2009 00:00:00 GMT

Use indentation and color in the current control on a form to highlight the current control.

Making a Searching List Box in Access 2007 (Visual How To)

Tue, 07 Apr 2009 00:00:00 GMT

Learn how to create a search list box by using a text box and a list box together, along with code that searches through a recordset or with code that searches directly through a table.

Creating SharePoint Sequential Workflows with Visual Studio 2008 (Visual How To)

Tue, 09 Sep 2008 00:00:00 GMT

Learn how to visually design the workflow structure, add code to handle events, and then press F5 to debug the workflow.

Creating Workflows to Transfer Records Upon Expiration in SharePoint Server 2007 (Visual How To)

Wed, 02 Jul 2008 00:00:00 GMT

Learn how you can create a workflow to transfer records and then associate the workflow as the action of an expiration policy in SharePoint Server 2007.

Preventing Document Modification using Windows SharePoint Services 3.0 (Visual How To)

Wed, 25 Jun 2008 00:00:00 GMT

Allow users to modify metadata but not file contents in Windows SharePoint Services 3.0 by using event handlers and by handling short-term and long-term check-out processes.

Preventing Record Modification in Windows SharePoint Services (Visual How To)

Wed, 25 Jun 2008 00:00:00 GMT

Use a custom Upload page to ensure that an existing file is not accidentally overwritten during the upload process in Windows SharePoint Services 3.0.

Building State Machine Document Approval Workflows for SharePoint Server 2007 Using Visual Studio 2008 (Visual How To)

Fri, 13 Jun 2008 00:00:00 GMT

Create powerful business tools by using state machine workflows to model real-world events and business processes in ways that are not available to sequential workflows.

Building an Expense Report Approval Workflow for SharePoint Server 2007 Using Visual Studio 2008 (Visual How To)

Wed, 04 Jun 2008 00:00:00 GMT

Learn how to create a sequential workflow for SharePoint Server 2007 to manage an expense report approval process.

Configuring and Deploying Workflows to SharePoint Server 2007 Using a Solution Package (Visual How To)

Wed, 04 Jun 2008 00:00:00 GMT

Learn how to use solution packages in SharePoint Server 2007 to configure and deploy workflows.

Creating Custom Workflow Activities for SharePoint Server 2007 Using Visual Studio 2008 (Visual How To)

Wed, 04 Jun 2008 00:00:00 GMT

Use Visual Studio 2008 to create custom activities in SharePoint Server 2007 that let you automatically send e-mail messages with attachments.

Creating a Custom Approval Workflow for SharePoint Server 2007 Using SharePoint Designer 2007 (Visual How To)

Tue, 03 Jun 2008 00:00:00 GMT

Use SharePoint Designer to create codeless workflows for SharePoint Server 2007 that can be attached to SharePoint lists.

Updating Document Information Panels for Content Type Changes in SharePoint Server 2007 (Visual How To)

Tue, 29 Apr 2008 00:00:00 GMT

Learn how to update a custom document information panel from SharePoint Server 2007 and from InfoPath 2007.

Creating Custom Routers in SharePoint Server 2007 (Visual How To)

Tue, 15 Apr 2008 00:00:00 GMT

Learn how to extend the router functionality in SharePoint Server 2007 to apply customized logic and business rules consistently to every new record in the records center.

Creating a Custom Expiration Formula Based On Metadata in SharePoint Server 2007, Part 2 (Visual How To)

Tue, 15 Apr 2008 00:00:00 GMT

Extend the existing expiration policy feature in SharePoint Server 2007 by creating a policy resource to implement a custom expiration formula.

Creating a Custom Expiration Formula Based On Metadata in SharePoint Server 2007, Part 1 (Visual How To)

Tue, 15 Apr 2008 00:00:00 GMT

Extend the expiration policy feature in SharePoint Server 2007 by creating a policy resource to implement a custom expiration formula.

Configuring Multiple Authentication Mechanisms with Alternate Access Mappings in Windows SharePoint Services 3.0 (Visual How To)

Tue, 15 Apr 2008 00:00:00 GMT

Learn how to configure a site collection with two entry points that use different authentication mechanisms in Windows SharePoint Services 3.0.

Automating Solution Package Creation for Windows SharePoint Services Using MSBuild (Visual How To)

Tue, 15 Apr 2008 00:00:00 GMT

By learning how to use MSBuild, you can create a cabinet file that includes all custom code and files that should be deployed to a SharePoint site.

Creating Document Libraries from List Items in Windows SharePoint Services 3.0 (Visual How To)

Fri, 11 Apr 2008 00:00:00 GMT

Learn how to create a document library when a new item is added to a list.

Batching Update List Items in Windows SharePoint Services 3.0 (Visual How To)

Fri, 11 Apr 2008 00:00:00 GMT

Use the ProcessBatchData command to update multiple items in a list by constructing and executing a batch of commands.

Using Secondary Lists to Maintain Relationships in SharePoint Server 2007 (Visual How To)

Thu, 10 Apr 2008 00:00:00 GMT

Learn how to extend a custom Relationship field in SharePoint Server 2007 to enable users to select a relationship type and store information in a secondary table.

Using Custom Fields to Display Relationships in SharePoint Server 2007 (Visual How To)

Thu, 10 Apr 2008 00:00:00 GMT

Learn how to use a field control to extend a custom Relationship field in SharePoint Server 2007 to retrieve and display document relationships from a secondary list.

Creating, Deploying, and Debugging Custom Timer Jobs in Windows SharePoint Services 3.0 (Visual How To)

Tue, 25 Mar 2008 00:00:00 GMT

Discover how to create a job that requests the home pages of all site collections in a Web application.

Programmatically Inheriting Field Values in Windows SharePoint Services 3.0 (Visual How To)

Tue, 25 Mar 2008 00:00:00 GMT

Learn how to set a default document metadata value by using a custom field type and control in Windows SharePoint Services 3.0.

Adding Code-Behind Files to Master Pages and Content Pages in Windows SharePoint Services 3.0 (Visual How To)

Tue, 25 Mar 2008 00:00:00 GMT

Use almost all the same techniques in ASP.NET 2.0 sites and in SharePoint sites since the architecture of Windows SharePoint Services is now based on ASP.NET 2.0.

Putting Multiple Items on Hold in SharePoint Server 2007 (Visual How To)

Tue, 18 Mar 2008 00:00:00 GMT

Learn how to programmatically apply a hold to all items in a folder in a records center in SharePoint Server 2007.

Using Metadata Tags to Route Documents to SharePoint Document Libraries (Visual How To)

Tue, 18 Mar 2008 00:00:00 GMT

Learn how to implement a custom router in SharePoint Server 2007 that routes documents to a specific folder in the records center by using metadata on the document instead of the content type.

Displaying Search Results In Grid Views in SharePoint Server 2007 (Visual How To)

Tue, 18 Mar 2008 00:00:00 GMT

Learn how you can bind search engine results to an SPGridView control to display the results in a grid format in SharePoint Server 2007.

Referencing and Linking: Using the Asset URL Selector in SharePoint Server 2007 (Visual How To)

Tue, 18 Mar 2008 00:00:00 GMT

Create a custom field in SharePoint Server 2007 that you can use to define a relationship between two documents.

Generating Unique IDs in Windows SharePoint Services 3.0 (Visual How To)

Thu, 28 Feb 2008 00:00:00 GMT

Learn to create a unique identifier in Windows SharePoint Services 3.0 for all items contained within a site.

Customizing List Views with XSLT Transformations in SharePoint Designer 2007 (Visual How To)

Thu, 28 Feb 2008 00:00:00 GMT

Learn how to use SharePoint Designer 2007 and custom XSLT to present data from a Windows SharePoint Services list as a bar graph through a Data View Web Part.

Customizing SharePoint List Views with SharePoint Designer 2007 (Visual How To)

Thu, 28 Feb 2008 00:00:00 GMT

Learn how to customize the Data Form Web Part in SharePoint Designer 2007 to display SharePoint list data and filter the data by using an ASP.NET drop-down list control.

Creating Workflow Association Pages for Windows SharePoint Services 3.0 (Visual How To)

Tue, 26 Feb 2008 00:00:00 GMT

Learn how to use an ASPX page to create an association between a custom workflow template and a container or a content type in Windows SharePoint Services 3.0.

Using Smart Clients to Communicate with Windows SharePoint Services Workflows (Visual How To)

Tue, 26 Feb 2008 00:00:00 GMT

Smart clients communicate remotely with Windows SharePoint Services 3.0 via a series of Web services. Learn how to harness this power within custom-built clients.

Deploying ASP.NET Web Applications in the Windows SharePoint Services 3.0 _layouts Folder (Visual How To)

Tue, 26 Feb 2008 00:00:00 GMT

Learn to use Visual Studio 2005 to create a simple ASP.NET 2.0 Web site that you can deploy to the SharePoint layouts folder.

Customizing Page Editing Toolbar Components in SharePoint Server 2007 (Visual How To)

Wed, 20 Feb 2008 00:00:00 GMT

Learn how to customize the Page Editing menu and the Quick Access buttons of the Page Editing toolbar in SharePoint Server 2007.

Building Custom Content Types in Windows SharePoint Services 3.0 (Visual How To)

Thu, 24 Jan 2008 00:00:00 GMT

Learn how to build a custom content type by using Visual Studio 2005 Extensions for Windows SharePoint Services 3.0.

Building Custom Workflow Conditions for SharePoint Designer (Visual How To)

Thu, 24 Jan 2008 00:00:00 GMT

Learn how to create a workflow condition assembly, sign the assembly, write the actual condition, and deploy the assembly to your SharePoint site.

Building Site Definitions with Visual Studio 2005 Extensions for Windows SharePoint Services 3.0 and SharePoint Designer 2007 (Visual How To)

Thu, 24 Jan 2008 00:00:00 GMT

Learn how to build a site definition for Windows SharePoint Services 3.0 by using the SharePoint Solution Generator.

Adding Code-Behind Files to Master Pages and Page Layouts in SharePoint Server 2007 (Visual How To)

Fri, 11 Jan 2008 00:00:00 GMT

Learn to use code-behind files within master pages and page layouts that are used in SharePoint Server 2007 WCM publishing sites.

Adding Custom Quick Access Buttons to the Page Editing Toolbar in SharePoint Server 2007 (Visual How To)

Fri, 11 Jan 2008 00:00:00 GMT

Learn to create and add custom buttons to the Quick Access button area of the Page Editing toolbar used in SharePoint Server 2007 WCM sites.