Re: Imporing defects into Quality Center from Excel
An alternative to using VBA is to use the Excel Add-in from QC. This allows you to import Excel data for Requirements, Tests, and Defects into QC. The information is available from QC by clicking on the Add-ins link on the home page.
If you want to write your own code to do the import then you need to learn the Open Test Architecture API. That documentation is available from within QC in the Documentation Library.