Is an opened Excel-Reference by TestComplete somehow hidden for other applications?
We have the following situation:
we start TestExecute 14 and get per OLEObject a reference to Excel.Application. We open a Workbook. An Excel-instance is opened with this Workbook. Another (Delphi) application opens and writes another Workbook. Both Workbooks appear in the same instance under Windows 7/Office 2010, so TestExecute can search the new Workbook in the only existing instance and work with it. So far so good.
Now we are using Windows 10/Office 2016: the Delphi-application opens another Excel instance instead of using the same instance of TestExecute!?! Is the TestExecute-Excel-Instance somehow hidden for other applications? We already set the registry entry 'disablemergeinstance' to 0, but this does not make any difference.
How can we search a Workbook in several instances? Or better, how can we make the TestExecute-Excel-Instance 'public'?
sincerely
P. Vinders
SOPTIM AG, Germany
Hi,
the following works for me with EXCEL7 in MSAA (Windows 7/10 and Office 2016):
Sys.Process("EXCEL").Window("XLMAIN", "*", 1).Window("XLDESK", "*", 1).Panel("*").NativeObject.Application
With this property I have all original Properties/Methods like before.
Thanks!
sincerely
P. Vinders
