hey krishh,
Function Write_Results2( nx, nx, act1, sheetNo, sheetname, sheetlocation)
Set objExcel=CreateObject("Excel.Application")
objExcel.Visible=True
objExcel.DisplayAlerts=False
Set objWorkbook=objExcel.Workbooks.Open(sheetlocation)
Set Excel_Wb=objExcel.Activeworkbook
Set Cursheet=Excel_Wb.Sheets(sheetno)
Cursheet.Name = sheetname
Cursheet.Cells(nX, nY).Value=act1
objWorkbook.SaveAs ( sheetlocation)
objExcel.Quit
Set objExcel = nothing
Set objWorkbook = nothing
End Function
it works damn good.. no doubt...
On Mon, May 24, 2010 at 10:28 PM, Roman Zilber <[email protected]> wrote:
> google excel automation vbscript
>
>
> On Mon, May 24, 2010 at 7:52 AM, Prasad Dev <[email protected]> wrote:
>
>> Use Filesystemobject to create a file and sedn the result in xls.
>> QTP as 3 XSL files:PDetails, PShort,Pselection..as the QTP result file
>> gennerated in XML format.You can use this file to export the result to XLS
>> file. ..This required knowledge of XSLT and Xpath
>>
>> THis is one way and second way of doing it is traverse the XML report file
>> and extrached the fields you want and copy it in Xls.
>>
>> OR you can use the custom reporting by creating the xls file while runtime
>> and fillup the things in the file depending upon the test result currently
>> running..
>>
>> Thanks,
>> Prasad.
>>
>>
>>
>>
>>
>>
>> On Mon, May 24, 2010 at 7:57 PM, krissh <[email protected]> wrote:
>>
>>> how to send qtp test results to an .xls file through vb scripting
>>>
>>> --
>>> You received this message because you are subscribed to the Google
>>> "QTP - HP Quick Test Professional - Automated Software Testing"
>>> group.
>>> To post to this group, send email to [email protected]
>>> To unsubscribe from this group, send email to
>>> [email protected]<mercuryqtp%[email protected]>
>>> For more options, visit this group at
>>> http://groups.google.com/group/MercuryQTP?hl=en
>>
>>
>> --
>> You received this message because you are subscribed to the Google
>> "QTP - HP Quick Test Professional - Automated Software Testing"
>> group.
>> To post to this group, send email to [email protected]
>> To unsubscribe from this group, send email to
>> [email protected]<mercuryqtp%[email protected]>
>> For more options, visit this group at
>> http://groups.google.com/group/MercuryQTP?hl=en
>>
>
> --
> You received this message because you are subscribed to the Google
> "QTP - HP Quick Test Professional - Automated Software Testing"
> group.
> To post to this group, send email to [email protected]
> To unsubscribe from this group, send email to
> [email protected]<mercuryqtp%[email protected]>
> For more options, visit this group at
> http://groups.google.com/group/MercuryQTP?hl=en
>
--
Thanks,
Mohan.
--
You received this message because you are subscribed to the Google
"QTP - HP Quick Test Professional - Automated Software Testing"
group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/MercuryQTP?hl=en
