03-07-2008, 04:46 PM
Its the same as writing any data to external data sheet...
You need to use Microsoft Excel Object Model for this
Steps are
1) Create Excel App object CreateObject("Excel.Application")
2) Open the file YourObjectName.Workbooks.Open filepath
3) Select the sheet ExcelObj.Sheets.Item
4) Select the cell where you wish to enter the value
ExcelObj.Sheets.Item.Cells(row,column)
Hope this would help you
You need to use Microsoft Excel Object Model for this
Steps are
1) Create Excel App object CreateObject("Excel.Application")
2) Open the file YourObjectName.Workbooks.Open filepath
3) Select the sheet ExcelObj.Sheets.Item
4) Select the cell where you wish to enter the value
ExcelObj.Sheets.Item.Cells(row,column)
Hope this would help you
Want to fast track your QTP/UFT Learning? Join our UFT Training Course