Project 2007: Managed Code Add-in for Importing Tasks from Excel

Microsoft Visual Studio Tools for the Office system (3.0) includes templates for developing Microsoft Office Project 2003 and Project 2007 add-ins. Learn how to develop and deploy an add-in that imports tasks from Excel to Project.
  • Version:


    File Name:


    Date Published:


    File Size:

    215 KB

      The download includes the complete Visual Basic and Visual C# sample code, developed with Visual Studio 2008 Professional Edition (Beta 2), for a Project 2007 add-in that imports task data from Excel. The ImportProject add-in sample (ImportProject_VB for Visual Basic) can be deployed with ClickOnce for easy installation of the add-in and prerequisites such as the .NET Framework 3.5 and Visual Studio Tools for Office Runtime libraries. The download also includes a sample Excel file with task data for testing the add-in. The add-in does the following jobs:
      • Adds a toolbar and button to Project that starts the Import From Excel dialog box.
      • Shows the application version and the ClickOnce published version of the add-in.
      • Allows the user to select the Excel file and worksheet, specify the column letters with the types of task data, and specify the row numbers to import for header and task data.
      • Converts subsets of the task data, such as task IDs, outline levels, and task predecessor IDs, so that the data is consistent for importing to Project.
      • Renames the Text1 task custom field to the name of the Excel column that contains the custom field data, and adds the custom field column to the view.
      • Allows the user to ignore a predecessor task that is a summary task, constrain the task start date, or choose a non-summary task as the predecessor.
      • Handles multiple predecessors for one task.
      • Indents tasks to the correct outline level according to the specified work breakdown structure (WBS).

      For a thorough discussion of the ImportProject add-in and how to develop, test, and deploy it, see Importing Tasks from Excel Using a Managed Code Add-in in the Technical Articles section for Project 2007 in the MSDN Library.
  • Supported Operating System

    Windows Server 2003 Service Pack 2, Windows Vista, Windows XP Service Pack 2

      This download works with the following applications:
      • Microsoft Office Project Professional 2007
      • Microsoft Office Project Standard 2007
      • Microsoft Office Excel 2007. Excel 2003 requires setting a reference to the corresponding version 11 of the Microsoft.Office.Interop.Excel assembly.
      • Microsoft Visual Studio 2008, Beta 2, or later
    • To install this download:
      1. Download the file by clicking the Download button near the top of this page and save the file to your hard disk.
      2. Double-click the pj12ImportProjectAddIn.exe file on your hard disk to start the setup program.
      3. Follow the instructions on the screen to complete the installation.
      To remove this download:

      To remove the download file, delete pj12ImportProjectAddIn.exe.

      The default installation directory is C:\ 2007 Office System Developer Resources\Project 2007 SDK\Code Samples\ImportProjectAddIn. To remove all the installed files, delete the installation directory.