Skip to main content

Visual Studio 2005 Team System: Software Project Management

Visual Studio Team System

Building Work Item Lists in Microsoft Excel

Project managers typically use Microsoft Excel to store lists of issues, work items, or even to schedule work. The Visual Studio Project Management tools provide a Microsoft Excel add-in that ties a list object in the spreadsheet to the work item database. The work item database is a where all work items such as bugs, risks, and tasks are stored.

Consider a scenario where a project manager creates a spreadsheet that includes the top 10 risks. As the project manager makes changes to the assignment, priority, and other fields on those risks, team members receive the updated information in their work item queues. The project manager no longer needs to query for status on the work item, but can pull that information directly from the work item database into the spreadsheet.

There are two ways to create a work item list. From the Portfolio Explorer (a view of the project in the Visual Studio IDE) a project manager can select a work item query or the documents node and create a new data-bound spreadsheet. The new spreadsheet will contain a work item list that is populated with the data from the query.

The project manager can also create a work item list from within Excel using the add-in to select a project and import work items.
Post a Comment

Popular posts from this blog

Compact and Repair an Access Database. Add Ref. to : AdoDb, Jro

< ?xml version="1.0" encoding="utf-8" ?>

using ADODB;
using JRO;
using System.Configuration;
using System.Data.OleDb;
using System.IO;

public class CompactAndRepairAccessDb : System.Windows.Forms.Form
private System.ComponentModel.Container components = null;
private JRO.JetEngine jro;
private System.Windows.Forms.Button btnConfirm;
private System.Windows.Forms.TextBox tbxOriginalDbSize;
private System.Windows.Forms.TextBox tbxCompactedDbSize;
private OleDbConnection cnn;

public CompactAndRepairAccessDb() {

FileInfo fi = new FileInfo( ConfigurationSettings.AppSettings["PathOriginal"] );
int s = Convert.ToInt32( fi.Length/1000 );
this.tbxOriginalDbSize.Text = s.ToString() + " kb";

private void btnConfirm_Click(object sender, System.EventArgs e) {
// First close all instances of the database

VBScript to Automate login into gmail

Dim IE
Dim crtScreen
Set IE = CreateObject("InternetExplorer.Application")
USERNAME = "saudaziz"

With IE
.navigate ""
End With

'wait a while until IE as finished to load
Do while IE.busy
set WshShell = WScript.CreateObject("WScript.Shell")
Do While UCase(IE.Document.readyState) <> "COMPLETE"
WScript.Sleep 100
set WshShell=nothing
IE.document.all.Item("Email").value = USERNAME
IE.document.all.Item("pASSWD").value =pASSWORD
Set IE = Nothing