Thanks but I'm aware of grid view export that won't get me what I want I want every detail of the test case including design steps grid view export will not do that I want that for all test cases not go one by one and cobble the info. I believe a macro or ota scripting is needed.

Hello,

You can do this from test plan. Go to test plan, then click on View and select ''Test Grid'' as the view choice. This gives you a grid style view. Here you can set the visible columns same as you would in Execution Grid or Defects Grid using the ''Select Columns'' menu button.

Once you have all your visible Column names present (these are your fields for test plan), simply filter your tests to the ones you want to export, or control select or however you need for the view to show the tests you want to export.

Right click on a test to see the right click menu options. At the bottom is option Export. Under it is Export All or Export Selected. The All gets all in the active view, while Export Selected will just get whatever you have highlighted before you did the right click.

Pick an option and windows save pop up comes up to name your Excel file. Name it and hit ok and your file will be saved. The file will have all the column names visible (all the fields you selected to be visible) and their data for each column.

This method does not do design steps, which is an option from the Analysis tab at the top. But that is not what you seem to want, you want the fields and multiple test select, which is what I discussed above.