Updated: August 2008
This topic is designed to help you find the answers to the following categories of common questions about programming with Visual Studio Tools for Office:
Setup and general tasks.
User interface customization tasks.
Excel automation tasks.
Word automation tasks.
Data tasks.
Server-side document management tasks.
Security tasks.
Deployment tasks.
For a more comprehensive list of topics about tasks in Visual Studio Tools for Office projects, see How Do I in Visual Studio Tools for Office.
How to: Create Visual Studio Tools for Office Projects.
How to: Upgrade Solutions from Visual Studio Tools for Office.
How to: Install Office Primary Interop Assemblies.
How to: Target Office Applications Through Primary Interop Assemblies.
How to: Create Event Handlers in Visual Studio Tools for Office.
How to: Open Office Solutions without Running Code.
How to: Set Up Configuration Information for an Office Solution.
How to: Show the Developer Tab on the Ribbon.
How to: Show Add-in User Interface Errors.
How to: Add Windows Forms Controls to Office Documents.
How to: Add NamedRange Controls to Worksheets.
How to: Add ListObject Controls to Worksheets.
How to: Add Content Controls to Word Documents.
How to: Add Bookmark Controls to Word Documents.
To add controls to documents and worksheets by using an application-level add-in, you must have Visual Studio 2008 Service Pack 1 (SP1). For more information, see Adding Controls to Office Documents at Run Time.
How to: Add an Actions Pane to Word Documents.
How to: Add an Actions Pane to Excel Workbooks.
How to: Add a Custom Task Pane to an Application.
How to: Display Custom Task Panes with E-Mail Messages in Outlook.
How to: Get Started Customizing the Ribbon.
How to: Change the Order of Tabs on the Ribbon.
How to: Customize a Built-in Tab.
How to: Customize the Microsoft Office Menu.
How to: Export a Ribbon from the Ribbon Designer to Ribbon XML.
How to: Add a Form Region to an Outlook Add-in Project.
How to: Prevent Outlook from Displaying a Form Region.
How to: Access the Outlook Item that Displays the Form Region.
How to: Add Smart Tags to Word Documents.
How to: Add Smart Tags to Excel Workbooks.
How to: Enable Smart Tags in Word and Excel.
How to: Create Smart Tags With Custom Recognizers in Word.
How to: Create Smart Tags With Custom Recognizers in Excel.
To create smart tags by using an application-level add-in, you must have Visual Studio 2008 SP1. For more information, see Smart Tags Overview.
How to: Create Office Menus Programmatically.
How to: Create Office Toolbars Programmatically.
How to: Display a String in a Worksheet Cell
How to: Send Values to Worksheet Cells
How to: Create New Workbooks.
How to: Open Workbooks.
How to: Save Workbooks.
How to: Close Workbooks.
How to: Add New Worksheets to Workbooks.
How to: Hide Worksheets.
How to: Move Worksheets Within Workbooks.
How to: Protect Workbooks.
How to: Refer to Worksheet Ranges in Code.
How to: Apply Styles to Ranges in Workbooks.
How to: Change Formatting in Worksheet Rows Containing Selected Cells.
How to: Search for Text in Worksheet Ranges.
How to: Print Worksheets.
How to: Run Excel Calculations Programmatically.
How to: Sort Data in Worksheets Programmatically.
How to: Create New Documents.
How to: Open Existing Documents.
How to: Save Documents.
How to: Close Documents.
How to: Reference Documents in the Documents Collection.
How to: Insert Text into Word Documents.
How to: Define and Select Ranges in Documents.
How to: Reset Ranges in Word Documents.
How to: Format Text in Documents.
How to: Add XMLNode Controls to Word Documents.
How to: Update Bookmark Text.
How to: Search for Text in Documents.
How to: Print Documents.
How to: Create Word Tables.
How to: Add Rows and Columns to Word Tables.
How to: Count Characters in Documents.
How to: Populate Worksheets with Data from a Database.
How to: Populate Documents with Data from a Database.
How to: Populate Documents with Data from Services.
How to: Populate Documents with Data from Objects.
How to: Update a Data Source with Data from a Host Control.
How to: Cache Data for Use Offline or on a Server.
How to: Programmatically Cache a Data Source in an Office Document.
How to: Programmatically Stop Caching a Data Source.
How to: Cache Data in a Password-Protected Document.
How to: Insert Data into a Workbook on a Server.
How to: Retrieve Cached Data from a Workbook on a Server.
How to: Change Cached Data in a Workbook on a Server.
How to: Add Custom XML Parts to Document-Level Customizations.
How to: Add Custom XML Parts to Documents by Using Application-Level Add-Ins.
How to: Add Custom XML Parts to Documents Without Starting Microsoft Office.
How to: Remove Managed Code Extensions from Documents (2007 System).
How to: Remove Managed Code Extensions from Documents (2003 System).
How to: Attach Managed Code Extensions to Documents (2007 System).
How to: Attach Managed Code Extensions to Documents (2003 System).
How to: Configure Inclusion List Security (2007 System).
How to: Add or Remove Inclusion List Entries (2007 System).
How to: Sign an Office Solution (2007 System).
How to: Grant Permissions to Folders and Assemblies (2003 System).
How to: Remove Permissions from Folders and Assemblies (2003 System).
How to: Grant Permissions to Documents and Workbooks in Shared Locations (2003 System).
How to: Deploy an Office Solution by Using ClickOnce (2007 System).
How to: Deploy Template Solutions That Run Code on a Network (2007 System).
How to: Deploy a Document-Level Office Solution to a SharePoint Server (2007 System).
How to: Install a ClickOnce Office Solution (2007 System).
How to: Uninstall a ClickOnce Office Solution (2007 System).
How to: Install Prerequisites on End User Computers to Run Office Solutions (2007 System).
How to: Prepare IIS for Deployment of Office Solutions (2007 System).
How to: Update Deployed Office Solutions (2007 System).
How to: Change the Installation Path of an Office Solution (2007 System).
How to: Prepare End User Computers to Run Office Solutions (2003 System).
How to: Deploy Office Solutions (2003 System).
How to: Deploy for Offline Use of Documents (2003 System).
Date
History
Reason
August 2008
Added links to recently added topics.
Information enhancement.