none
Office Integration with TFS RRS feed

  • Question

  • Hi,

    I'm working on the custom integration tool with the TFS. My tool have a funtionality to open Ms Project (and Excel) from the query result that query from tfs just like the functionality that provided in TE when right click the workitem in the query result and then select "Open Selection in Microsoft Project".

    Would it be possible to create a custom code to perform above?

    I know only that I can use  Microsoft.Office.Interop.MSProject to lunch MS Project but i couldn't find the API that i can use to integrate with the TFS-Add in that are provided in Office.

    I guess that we may have to use Microsoft.TeamFoundation.OfficeIntegration dll. But I couldn't find this dll and don't know how to use it?

    Thank you.
    Monday, January 5, 2009 9:57 AM

Answers

  • Hi,

    You need to refer to Project Object Model to achieve your goal, as far as I could tell is Following :

    Start a Project session by using the Microsoft.Office.Interop.MSProject.Application Object,

      Microsoft.Office.Interop.MSProject.Application app = new Microsoft.Office.Interop.MSProject.Application();
                app.FileOpen()

    More Information about FileOpen method:
    http://msdn.microsoft.com/en-us/library/bb213548.aspx


    However Project is not a part of VSTO technology.

    Thanks
    • Marked as answer by KPT Monday, January 12, 2009 8:53 AM
    Monday, January 12, 2009 5:21 AM

All replies

  • Hi ,

    I'm not sure about your question, are you working with a VSTO project?If you are not please check Sticky: PLEASE READ FIRST - What is VSTO and non-VSTO resources post at very top of the forum.

    Thanks
    Friday, January 9, 2009 8:34 AM
  • Hello KPT,

    as I know TFS is mostly a Webservice.
    Normally you can access it as any other Webservice from VSTO AddIns.

    For me it's not clear what exactly you want to do.
    Write an Office AddIn and access TFS Services - or write an Visual Studio AddIn and automate automate Office Application.
    Both is possible.

    Have a look here:
    http://www.personifydesign.com/products/teamlook/discover.aspx


    Maybe clarify what you want to archive.

    Greets - Helmut
    Helmut Obertanner [http://www.x4u.de] [http://www.outlooksharp.de]
    Saturday, January 10, 2009 12:03 PM
    Answerer
  • Hi Helmut Obertanner,

    Thank you for your answer, i'm going to create the add-in similar like TeamLook with some special internal requirement. In the teamlook, from the query result, I would like to select work item and then has a functionallity to open the selected work items in Ms Project or Excel. So I would like to know that will Ms Project has an option to call from the add-in project.

    I also wonder that will microsoft create their own add-in for outlook for now i found only the third party company that create and add-in to the outlook

    Thank you
    Monday, January 12, 2009 2:51 AM
  • Hi,

    You need to refer to Project Object Model to achieve your goal, as far as I could tell is Following :

    Start a Project session by using the Microsoft.Office.Interop.MSProject.Application Object,

      Microsoft.Office.Interop.MSProject.Application app = new Microsoft.Office.Interop.MSProject.Application();
                app.FileOpen()

    More Information about FileOpen method:
    http://msdn.microsoft.com/en-us/library/bb213548.aspx


    However Project is not a part of VSTO technology.

    Thanks
    • Marked as answer by KPT Monday, January 12, 2009 8:53 AM
    Monday, January 12, 2009 5:21 AM
  • Hi Helmut,

    Thank you for your answer,
    I would like to know that does microsoft have a plan to include Project as part of VSTO technology in the near future. Or will the microsoft has a plan to create outlook-addin for TFS integration in the near future?


    Thank you
    Monday, January 12, 2009 9:59 AM