I need to identify the particular cell in an excel which was opened during script execution. Please guide me
Was the excel opened by the QTP script or externally?
It will be opened by the script during execution
U can use Excel object to retrieve the cell value
Winds of Change
How are you opening it?
If its a datatable then:
DataTable.Value(ParameterID [, SheetID]) should do.
OR if you are creating an object you can use:
set sExcelObj = CreateObject("Excel.Application")
sExcelObj.Visible = true
set sWorkBook = sExcelObj.Workbooks.open("c:\book1.xls")
set sWorkSheets = sWorkBook.worksheets ("Sheet1")
sValue = sWorkSheets.cells(3,1).value
Set xlApp = GetObject(, "Excel.Application")
But if using GetObject, an instance of excel object needs to be available loaded in the memory right.