Micro Focus QTP (UFT) Forums
GetObject with 2 applications open - Printable Version

+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: VB Scripting/Descriptive Programming (https://www.learnqtp.com/forums/Forum-VB-Scripting-Descriptive-Programming)
+--- Thread: GetObject with 2 applications open (/Thread-GetObject-with-2-applications-open)



GetObject with 2 applications open - berula - 03-15-2011

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