03-15-2011, 06:19 PM
Hi all,
I search a way to use GetObject when Excel is open 2 times.
I test a Application (VB) that open's an Excel an then put data into an ExcelSheet.
I must read this data in QTP, but if I hook to Excel with
Set objExcel = GetObject(,"Excel.Application")
their is a hiden Excel with no Workbook open.
In TaskManager I can see that there are 2 Excel open, but only one ist visible.
How can I access the second Excel. this 2. Excel has an Workbook and an active Sheet.
Is there a way to hook into an Applikation with an ID,PID, Index or so on?
thanks
Ralf
I search a way to use GetObject when Excel is open 2 times.
I test a Application (VB) that open's an Excel an then put data into an ExcelSheet.
I must read this data in QTP, but if I hook to Excel with
Set objExcel = GetObject(,"Excel.Application")
their is a hiden Excel with no Workbook open.
In TaskManager I can see that there are 2 Excel open, but only one ist visible.
How can I access the second Excel. this 2. Excel has an Workbook and an active Sheet.
Is there a way to hook into an Applikation with an ID,PID, Index or so on?
thanks
Ralf