Office

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

    Language:
    English
    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:

      Aug07

      File Name:

      pj12ImportProjectAddIn.exe

      Date Published:

      8/27/2007

      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.

    Popular downloads

    Loading your results, please wait...

    Free PC updates

    • Security patches
    • Software updates
    • Service packs
    • Hardware drivers

    Microsoft suggests

    Buy Office 365, get 1 TB OneDrive file storage.
    Get things done from virtually anywhere
    Buy Office 365 and get 1 TB of file storage from OneDrive.
    Buy now