VSTO and VSTS integration  
Author Message
Yuhang





PostPosted: Team Foundation Server - Work Item Tracking, VSTO and VSTS integration Top

Scenario:

In VS.NET Team Suite 2005, click an excel file. The file is opened in Excel and then a query is performed against the team foundation server to retrieve a list of work item.

Question:

How/where does the Excel VSTO get the connection string to the team foundation server

Thanks,

Yuhang.



Visual Studio Team System8  
 
 
Dennis Habib MSFT





PostPosted: Team Foundation Server - Work Item Tracking, VSTO and VSTS integration Top

Hi,

I assume that you are referring to the .xls files that are found under the 'Documents' node in the Team Explorer. Some of the .xls files are modified on their way up to the server during Team Project Creation. The name of the server an a GUID for the query to run are embedded in the .xls file at that time. Also, the Excel addin does not use VSTO. VSTO is required for it to operate, but only because of the 'CLR lockback' issue (starting the CLR from within Excel will always launch the .Net 1.1 version of the CLR unless VSTO 2005 runtime is installed)

-Dennis


 
 
gunman69





PostPosted: Team Foundation Server - Work Item Tracking, VSTO and VSTS integration Top

I'm interested in more information on how the Excel-integration with VSTS work-items works (we would like to do something similar in our project).

Can someone briefly describe how the integration works If there is any sample source code, that would be ideal, of course.

Thanks!

/Fredrik