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)...
paulvinders's avatar
paulvinders
Contributor
6 years ago

Hi Alex,

 

thanks for the reply. Testcomplete is the first application which starts opening Excel-Workbooks. The other Delphi-application creates/fills Workbooks during testexcution. So no Excel-instance runs at Start...

  • tristaanogre's avatar
    tristaanogre
    Esteemed Contributor
    6 years ago

    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