cancel
Showing results for 
Search instead for 
Did you mean: 

Excel application does not launch properly using Tested Apps

SOLVED
Highlighted
Occasional Contributor

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.

We launch excel using TestedApps object and then control excel using COM objects.

We are facing an issue while launching excel in which sometimes the Excel gets stuck on the initial pop-up while launching and doesn't proceed. The TestComplete also doesn't respond to this and keeps waiting for the excel to launch. Sometimes it waited for more than 2 days before it was manually terminated.

Has anyoe else faced this issue or know how to fix it kindly post it here.

 

 

Thanks,

Yusuf

Tags (2)
1 ACCEPTED SOLUTION

Accepted Solutions
Community Hero

Re: Excel application does not launch properly using Tested Apps

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.


Robert Martin
[Community Expert Group]
Please consider giving a Kudo if I write good stuff
----

Why automate?  I do automated testing because there's only so much a human being can do and remain healthy.  Sleep is a requirement.  So, while people sleep, automation that I create does what I've described above in order to make sure that nothing gets past the final defense of the testing group.
I love good food, good books, good friends, and good fun.

Mysterious Gremlin Master
Extensions available
1 REPLY 1
Community Hero

Re: Excel application does not launch properly using Tested Apps

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.


Robert Martin
[Community Expert Group]
Please consider giving a Kudo if I write good stuff
----

Why automate?  I do automated testing because there's only so much a human being can do and remain healthy.  Sleep is a requirement.  So, while people sleep, automation that I create does what I've described above in order to make sure that nothing gets past the final defense of the testing group.
I love good food, good books, good friends, and good fun.

Mysterious Gremlin Master
Extensions available
New Here?
Join us and watch the welcome video:
API Testing Mistake #2
APITestingMistake#2
Top Kudoed Authors