Have you ever thought ‘I know that you get the Team ribbon in Excel to manage TFS work items, and I can use Excel to as a SQL/OLAP client to run reports from the TFS warehouse but I want to do more….’?
Have you every considered using VSTO to create an ActionPane that uses the TFS .NET API?
In this example I have created an ActionPane that allows you to select a Team Project Collection, a Team Project and then a build definition. Press the button and it lists the builds that have run of this type using the TFS .NET API.
The code can be downloaded here, it is fairly basic, could be more exception handling for connection failures, but shows the principle.