Vinod123, Question in context is not about getting result report in html, the question is display the content of the web table in html and generate.
Ravi.gajul has correctly replied, we have to use file system object to write the content in the html way. use proper formatting as well to display the content in aligned way.
Below is what I tried and working-
Ravi.gajul has correctly replied, we have to use file system object to write the content in the html way. use proper formatting as well to display the content in aligned way.
Below is what I tried and working-
Code:
Set fso = CreateObject("Scripting.FileSystemObject")
Set MyFile = fso.CreateTextFile("C:\Documents and Settings\" & Environment("UserName") & "\Desktop\testResult_"& myDate & "-" & myTempTime &".html", True)
MyFile.WriteLine "<!DOCTYPE HTML PUBLIC ""-//W3C//DTD HTML 4.0 Transitional//EN"">"
MyFile.WriteLine "<HTML>"
MyFile.WriteLine "<HEAD>"
MyFile.WriteLine "<TITLE> Sanity Tests run on Magnet Dev</TITLE>"
MyFile.WriteLine "<META http-equiv=Content-Type content="&Chr(34)&"text/html; charset=windows-1252"&Chr(34)&">"
MyFile.WriteLine "<STYLE type=text/css>TD {"
MyFile.WriteLine "FONT-SIZE: 10pt; FONT-FAMILY: Verdana"
MyFile.WriteLine"}"
MyFile.WriteLine "</STYLE>"
MyFile.WriteLine "<META content="&Chr(34)&"MSHTML 6.00.6000.17107"&Chr(34)&" name=GENERATOR></HEAD>"
MyFile.WriteLine "<BODY>"
MyFile.WriteLine "<TABLE borderColor=#336699 cellSpacing=2 cellPadding=2 bgColor=#ffffcc border=2><TBODY>"
MyFile.WriteLine "<tr>"
MyFile.WriteLine "<th bgColor=#ccffff> Action Performed</th>"
MyFile.WriteLine"<th bgColor=#ccffff> Expected Result</th>"
MyFile.WriteLine "<th bgColor=#ccffff> Actual Result</th>"