Export WebElement value to Excel

[sssidana]

Hello everyone I am trying to export the innertext value of webelement value to the excel sheet.I was able to get it in the msgbox but not in excel.help...!!!

[ravi.gajul]

Hi,
Please see the code below for your reference

Code:

strText=Browser(...).Page(...).getRoproperty(....)
'Create Excel app
Set objAppExcel=CreateObject("Excel.Application")
objAppExcel.visible=True
'Open the worksbook
objAppExcel.workbooks.open "D:\Test.xls"
'Set focus on the workbook
objAppExcel.Workbooks("Test.xls").Activate
'Create work sheet obj
Set objExcelSheet=objAppExcel.ActiveWorkbook.Worksheets(1)
'Write to work sheet
objExcelSheet.cells(1,1)=strText
'Save worksheet
objExcelSheet.saveAs "D:\Test.xls"
'Clear  obj reference
Set objExcelSheet=Nothing
'quit app
objAppExcel.quit
Set objAppExcel=Nothing

Regards,
Ravi

[sssidana]

Thanks a lot,,it worked