Export (0) Print
Expand All
4 out of 6 rated this helpful - Rate this topic

Excel Solutions

Applies to

The information in this topic applies only to the specified Visual Studio Tools for Office projects and versions of Microsoft Office.

Project type

  • Document-level projects

  • Application-level projects

Microsoft Office version

  • Excel 2003

  • Excel 2007

For more information, see Features Available by Application and Project Type.

Visual Studio Tools for Office provides project templates you can use to create document-level customizations and application-level add-ins for Microsoft Office Excel. You can use these solutions to automate Excel, extend Excel features, and customize the Excel user interface (UI).

For more information about document-level customizations, see Excel Document-Level Customization Development. For more information about application-level add-ins, see Getting Started Programming Application-Level Add-Ins.

Create the following types of Excel projects by using the project templates in the New Project dialog box:

  • Excel add-in

  • Excel workbook

  • Excel template

This template includes required assembly references and project files. Visual Studio Tools for Office provides a version of these templates for Microsoft Office 2003 and the 2007 Microsoft Office system.

For more information about how to create an Excel project, see How to: Create Visual Studio Tools for Office Projects. For more information about the project templates, see Visual Studio Tools for Office Project Templates Overview.

The Excel object model exposes many types that you can use to automate Excel. For example, you can programmatically create worksheets, and set the values of ranges and cells. For more information, see Excel Object Model Overview.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.