Forum Discussion

mesg2anil's avatar
mesg2anil
Regular Contributor
13 years ago

Export Test Results To Excel Sheet

Hi, Please help me with code, on how to export test results to excel sheet..
TanyaYatskovska's avatar
TanyaYatskovska
SmartBear Alumni (Retired)
11 years ago

Hi Jenifer,


 


I've answered you in the TestComplete LinkedIn group. Here is the copy of my reply:


 


You can use the Hyperlinks.Add Method method - http://msdn.microsoft.com/en-us/library/office/ff822490.aspx


 


I have a sample that adds a hyperlink to a Word document - maybe it will help:


 




 'VBScript


 Sub Main 


 Dim strLink, oWord, oDoc, oRange, oHL


  



 Set oWord = Sys.OleObject("Word.Application") 


 oWord.Visible = True 


 Set oDoc = oWord.Documents.Add 


 Set oRange = oDoc.Range 


 Set oHL = oRange.Hyperlinks.Add(oRange, strLink, False, False, "Sample") 


 End Sub