masakowitz
New Member
Hi all!
I am not a VBA programmer but from the brief research I did it seems I need VBA code to as a solution. I have a query in TFS which I export to Excel. I want to refresh the excel datasheet (Data) with a Macro - one that I can ultimately create a button for the user to open and push. Recording a macro using the Team tab and pressing Refresh does not work - I get an error
TF208102: You have performed an Excel sort on a tree list. This action removed the modified or newly introduced hierarchical link relationships of the tree.You can still publish the changes you have made to individual work items. After you publish, the list will restore to previous hierarchy.In general, you should not sort a tree list whose hierarchy has been modified.
Can someone help build VBA code I can copy in to create a Macro for this purpose?
Thanks
Mark
PS - I see sample posts online but I do not know what I am reading or how to customize it for my use.
I am not a VBA programmer but from the brief research I did it seems I need VBA code to as a solution. I have a query in TFS which I export to Excel. I want to refresh the excel datasheet (Data) with a Macro - one that I can ultimately create a button for the user to open and push. Recording a macro using the Team tab and pressing Refresh does not work - I get an error
TF208102: You have performed an Excel sort on a tree list. This action removed the modified or newly introduced hierarchical link relationships of the tree.You can still publish the changes you have made to individual work items. After you publish, the list will restore to previous hierarchy.In general, you should not sort a tree list whose hierarchy has been modified.
Can someone help build VBA code I can copy in to create a Macro for this purpose?
Thanks
Mark
PS - I see sample posts online but I do not know what I am reading or how to customize it for my use.