I am new to VB, i want to extract all the queried defects from defects module to excel sheet at a click of button.
I will be providing the below details in excel sheet itself,
I will be querying the summary field in defects module, to pull the defects that i need
Query example: "login Or Authentication"
PLease help me how to program the VB code for the above
Please see the website you will get an idea of how to write http://blogs.exposit.co.uk/category/qualitycenter/
Why bother writing VBA in Excel when you can use the Excel Report Generator in QC?.. it will do it all for you, incluing any post processing (formatting, graphs, pivot tables/charts) that you want.
To use excel with a button, you still need to be able to 'see' Quality center, so you might as well keep it simple use what's provided in the tool.
... just another Tester ...