I'm trying to connect to our Team Foundation Server from Excel using VB code
or a macro, to import the list of open work items.

I've tried recording a macro while I'm going through querying the TFS from
Excel (menu Team... New List... etc...), but the macro recording doesn't seem
to be recording the data import, it only records the autofilter part after
the TFS data has been imported.

How can I automatically import a list of work items into an Excel sheet ?