VBA Code to export test cases and defects from Quality Center to an excel sheet?

[hektor]

Hi Friends,
Can anyone give me the VBA code (or) give the links to a page , which shows how to export test cases and defects from Quality Center to an excel sheet? I've done a lotta googling and came up with some code, but i get a strange error code while specifiying the "nodeByPath" function ? Googling doesnot provide anything there. Please help someone , as this is very urgent.

Thanks in advance...

 

[tifosi]

You could try writing a SQL query to get stuff directly from the db and write it into the excel.

 

[asingh]

Post your code here, if you can.