Code:
Set ObjExcel=CreateObject("Excel.Application")
Set objWorkbook = ObjExcel.Workbooks.add
Set objWorksheet = objWorkbook.Worksheets(1)
objWorksheet.Name = SheetName
'ObjExcel.Visible=True
'to write values to the cells....
Code:
objWorksheet.cells(1,1)="Property"
objWorksheet.cells(1,2)="Validation"
objWorksheet.cells(1,3)="Outcome"