I am a QTP cum Performance test engineer and my level of experience with QC is simply log a bug and doing follow ups. Currently i am doing a POC for client to automate Dashboard reports automation. We have to run the SQL query from Excel Macro or VBscript then download the results or graphs on local machine. I had a search and developed below snippet.
I am able to run above code without any issues but I need to download the generated report as excel file, so please help me on this.
Set QCConnection = CreateObject("TDApiOle80.TDConnection")
Set com = QCConnection.Command
com.CommandText = "SELECT BUG.BG_CLOSING_DATE FROM BUG WHERE BUG.BG_USER_08 = '07/26/2013'"
Set recset = com.Execute