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