Forum Discussion

Yusufm87's avatar
Yusufm87
Contributor
6 years ago

How to close Excel window cleanly

Hi,    I need to close Excel application opened using TestApps["EXCEL"]["Run"] method. I have tried closing the excel using the TestedApp["Close"]() method but it only closes the Excel window. ...
Yusufm87's avatar
Yusufm87
Contributor

Hi Shankar,

 

Thank you for you solution. But as I mentioned in my message that using ["Terminate"]() causes application to misbehave, I cannot use it under the circumstance.

In our test cases we are verifying various fields in Excel and checking if the formulas work. We are not retrieving any test data from excel.

 

 

Best Regards,

Yusuf

shankar_r's avatar
shankar_r
Community Hero
6 years ago

In order to check the formula, you have to retrieve the value from excel validate whether the value is being calculated correctly.

If this statement is true in your case then you can very well use DDT.ExcelDriver() to retrieve the value and verify

    • Manfred_F's avatar
      Manfred_F
      Regular Contributor
      6 years ago

      hi,

      my Excel-closing routine works as follows:

       

      While Excel Process exists

         get visible "XLMAIN" Windows

         If #XLMAIN > 0 Then

            Set ExcelApp = Xlmainwindow.Window("XLDESK").Window("EXCEL7").NativeObject.Application.Application

            For Ix = ExcelApp.Workbooks.Count To 1 Step -1

               ' close Workbooks without saving

               If ExcelApp.Workbooks(Ix).Windows(1).Visible Then ExcelApp.Workbooks(Ix).Close False

            Next

            ExcelApp.Quit

            Set ExcelApp = Nothing

         End IF

      End While