Visual Studio Tools for the Microsoft Office System

Walkthroughs Using Excel

Note	Required applications
The features in this topic are available only if you have the required applications installed. For more information, see Features Available by Product Combination.	One of these development environments: VSTO 2005 -or- Visual Studio Team System Microsoft Office 2003

Note

Required applications

The features in this topic are available only if you have the required applications installed.

For more information, see Features Available by Product Combination.

One of these development environments:

VSTO 2005

-or-

Visual Studio Team System
Microsoft Office 2003

Walkthroughs provide step-by-step instructions for common scenarios and are a good place to start learning about Microsoft Visual Studio 2005 Tools for the Microsoft Office System.

The following walkthroughs demonstrate several basic types of tasks: automating Microsoft Office Excel 2003, performing data analysis, working with controls, deploying solutions, and setting security.

In This Section

Walkthrough: Collecting Data Using a Windows Form: Illustrates using a Windows Form to collect user input and then sending the input to a cell in an Excel worksheet.

Walkthrough: Changing Worksheet Formatting Using CheckBox Controls: Demonstrates the basics of using check boxes on an Excel worksheet to change formatting.

Walkthrough: Displaying Text in a Text Box in a Worksheet Using a Button: Demonstrates the basics of using buttons and text boxes on Excel worksheets.

Walkthrough: Programming Against Events of a NamedRange Control: Provides step-by-step instructions on how to add a NamedRange control to a worksheet and program against its events.

Walkthrough: Binding a Worksheet Cell to a Database Field: Demonstrates the basics of binding a single data field in a SQL Server database to a named range in Excel.

Walkthrough: Binding Cells to Multiple Columns in a Table: Demonstrates the basics of binding multiple cells in an Excel worksheet to fields in the Northwind SQL Server database.

Walkthrough: Creating a Master/Detail Relation Using a Cached Dataset: Demonstrates creating a master/detail relation on a worksheet, and caching the data so that the solution can be used offline.

Walkthrough: Updating a Chart in a Worksheet Using Radio Buttons: Shows the basics of changing chart styles using radio buttons on an Excel 2003 worksheet.

Walkthrough: Binding Data to Controls on an Excel Actions Pane: Describes how to add controls that are bound to a data source to an actions pane in Excel.

Walkthrough: Deploying a Document-Level Customization Using a Deployment Manifest: Demonstrates how to publish a Word or Excel solution and then redeploy the solution to a new network location.

Walkthrough: Deploying a Document-Level Customization Using a Windows Installer File: Demonstrates how to create a Windows Installer file that can be used to deploy a Word or Excel solution.

Walkthrough: Granting and Removing Permissions for an Office Solution: Demonstrates step-by-step how to remove the default permissions granted during project creation and add permissions based on strong name.

Related Sections

Walkthroughs Using Word: Lists step-by-step guides that provide an introduction to Visual Studio Tools for Office and help to illustrate how you can create applications that take advantage of Microsoft Office Word 2003.

Data Walkthroughs (Visual Studio Tools for Office): Lists step-by-step guides that illustrate how to work with data in your solutions.

Actions Panes and Smart Tags Walkthroughs: Lists step-by-step guides that illustrate how you can create applications that take advantage of actions panes and smart tags.

Security and Deployment Walkthroughs: Lists step-by-step guides that illustrate how you can set security policy to allow your solution to run, and how you can deploy your solution.

Office Development Samples: Provides links to sample applications that illustrate the use of managed code extensions with Word and Excel.

Getting Started (Visual Studio Tools for Office): Provides links to information on setup, project templates, Office primary interop assemblies, and what's new in Office development.

Common Tasks in Office Programming: Lists frequently asked questions about programming with Visual Studio Tools for Office, and provides links to topics that can help solve common problems.

Creating Office Solutions in Visual Studio: Provides links to information on creating Word and Excel solutions and the role of assemblies in your solution.