I have written a Macro that once run from Excel, logs into Quality Center (v10.0) and extracts and dumps stated defect data into a tab within the Excel workbook ... i.e. purpose is to see all defects that we have assigned to a Release

I am trying to incorporate the same process to Test Lab ... so that in addition to all defects assigned to a Release, I could extract (and dump into a seperate tab) all Tests assigned to the same Release - and there current Exection status

Reasoning behind the above - once data is into excel workbook, I can use this to populate a Release Report that is currently ran but Generating Excel reports from the Quality Center dashboard.

Thanks for any thoughts / solutions!!