Forum Discussion

paulvinders's avatar
paulvinders
Contributor
6 years ago

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)...
tristaanogre's avatar
tristaanogre
Esteemed Contributor

Using OleObject('Excel.Application') creates a running Excel instance.  So, as soon as you call that in TestComplete, a running instance is created.  Hence, the article AlexKaras posted still applies

paulvinders's avatar
paulvinders
Contributor
6 years ago

Hi,

 

After adding EXCEL7 in MSAA, the Property is visible not visible under

Sys.Process("EXCEL").Window("XLMAIN", "a - Excel", 2).Window("XLDESK", "", 1).Window("EXCEL6", "", 1). It is visble under Sys.Process("EXCEL").Window("XLMAIN", "a - Excel", 2).Window("XLDESK", "", 1).Panel("a"). Sys.Process("EXCEL").Window("XLMAIN", "a - Excel", 2).Window("XLDESK", "", 1).Window("EXCEL7", "", 1) has disappeared.

Instead of adding EXCEL7, I've added only EXCEL6 in MSAA: then the property is visible under Sys.Process("EXCEL").Window("XLMAIN", "a - Excel", 2).Window("XLDESK", "", 1).Window("EXCEL7", "a", 1) -- EXCEL 7 !!!!!!!!

 

Also, a Sys.Process("EXCEL").Window("XLMAIN", "", 3 exists though 2 files are opened, not 3...

I don't understand it.

  • paulvinders's avatar
    paulvinders
    Contributor
    6 years ago

    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