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. |
|
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.
