Vbscript To Export Test Cases From Qc To Excel

/ Comments off
Vbscript

Vbscript To Export Test Cases From Qc To Excel Online

Hi,
I have a tool that capture screenshots of the application that we test at our workplace. Now once I complete my testing of a particular test case or scenarios, we attach the screenshot that we have taken to HP Quality Center manually.
I want to automate this and make my tool to upload the word document to a test in QC Test Lab. Is this possible? If Yes, How can we do this in Excel VBA?
Operations that we need to perform would be as below:
1. Connect to QC project with login credentials, domain & project details
2. Pick a file(s) from a local folder
3. Upload a file(s) to QC Test Lab, specific test case

Please Note: The test case for which the attachment has to be made must be parametrized.

- Captain Cool

Please help me how to export test cases from ALM to Excel sheet from ALM itself. I mean from which tab in ALM to refer and from where to run Vb or SQL query to export the desired test cases from ALM to Excel sheet if any add in available built by HP ALM please let me know Thanks in Advance, Vinrocks!