Forum Discussion

Yusufm87's avatar
Yusufm87
Contributor
6 years ago

Excel application does not launch properly using Tested Apps

Hi,    We have requirement of testing an Excel Add-in. To test it we open Excel, Load the add-in, generate formulas and extract data using the add-in and compare the outcome with expected values....
Add-ins
excel
  • tristaanogre's avatar
    tristaanogre
    6 years ago

    I haven't personally faced the problem but I have some thoughts.  It is possible that, when using the COM objects, there may be an instance of Excel that is not getting properly closed down.  So, when TestComplete goes to launch Excel, it can't because of that instance of Excel.

     

    What you might want to do is check to see if there is an Excel process running in memory on the machine and, if so, terminate it before launching the application.

tristaanogre's avatar
tristaanogre
Esteemed Contributor
6 years ago

I haven't personally faced the problem but I have some thoughts.  It is possible that, when using the COM objects, there may be an instance of Excel that is not getting properly closed down.  So, when TestComplete goes to launch Excel, it can't because of that instance of Excel.

 

What you might want to do is check to see if there is an Excel process running in memory on the machine and, if so, terminate it before launching the application.