PDA

View Full Version : TFS Connection using Excel VBA



the_tman69
02-14-2012, 06:31 AM
Could anyone provide the VBA code to connect to TFS from Excel VBA, without using the Team Ribbon UI or creating any external DLL files.

The goal is to create an Excel template form which allows the user to enter data in fields then press a button which will connect to TFS and create multiple work items. I have searched and searched and have yet to find an example of how to accomplish this task without external files or referencing the Team Ribbon UI. I have the power tools installed and have the ribbon installed but would like this to all be done using VBA code only.

Thanks!
Tim