Hello All,

Please help me out in understanding following questions w.r.t using excel macros to talk with QC

1. Which is the best method to use for connecting to QC to extract data say Defects?
OTA or Querying directly to QC DB

2. I want to have a customized report in excel which is connected to QC. This report will be used by different people having access to QC.

3. If I use OTA, What are requirements before I start coding?
If I start querying directly to QC DB, what are the settings(permissions,config....) I require to start coding?

It would be really great if you guys help me out with this.