| || |
Extract bug information from QC to Excel using VBA
This has probably been posted elsewhere, but I cant for the life of me find it.
Anyway, I'm trying to extract defect info from QC into Excel using a VB script (I want to automate my daily report), however I'm struggling with the VB scripting.
Can anyone help me by giving me an example of the code I can use, please?
I'd like to be able to (ideally) hit a button in Excel that says 'Extract data', and for the code to then extract from QC the number of defects, severities of defects etc.
Any help/guidance would be appreciated. I'm running Excel 2007.
Thanks in advance.
Re: Extract bug information from QC to Excel using VBA
What version of QC? In ALM11 in the Analysis view there is the Excel Reports section where you can custom up excel reports that query the database.
You can also just query QCs backend database like any other database and use the documentation in ALM database reference document to guide you.