Using Quality center api to get Bug/Defect history by a Macro in Excel
Here is the code that will get you the bug history of a particular defect in Quality center..
1)To run this code ,Open Excel and Press ALT+F11 to go to Visual Basic Editor and paste this code .
2)Replace the url with your QC url
3)Replace username and password with your own username and password
Dim QCConnection
Set QCConnection = [...]