Forum Discussion

xuerzj's avatar
xuerzj
New Contributor
9 years ago

Is there a way to close all open excel drivers?

Sometimes the test is failed and then stopped before closing the excel driver. Then it starts to run the next test. The next test also creats a driver with same name, as a result it uses wrong excel ...
Ravik's avatar
Ravik
Super Contributor
Hi, First you have to check in your Test is there any process is running for excel, If its running close it. Do one thinng - Add Excel process in Name Mapping and check like below - Sub CloseExcel Set objExcelKill = NameMapping.Sys.EXCEL Do while objExcelKill.Exists = True objExcelKill.Terminate Loop Set objExcel = CreateObject("Excel.Application") objExcel.DisplayAlerts = False objExcel.Visible = True End Sub This may help you.
xuerzj's avatar
xuerzj
New Contributor
9 years ago

Thanks for your input. 

 

It is not working for me. When a excel driver is created, the excel object does not exist. 

 

Any suggestion? Thank you.

  • leandroaraujoso's avatar
    leandroaraujoso
    Contributor
    9 years ago

    Hi xuerzj,

     

    You could create an OnStopTest event. In this event you would check weather or not exists an open Excel connection and then close it.

     

    Regards,

     

    Leandro de Araújo Souza

    • xuerzj's avatar
      xuerzj
      New Contributor
      9 years ago

      Hi Leandro,

       

      Thanks for your input. Actually I don't know how to check weather or not a excel driver exists.

       

      I use the following command to create and close excel drivers. 

       

      Set Driver = DDT.ExcelDriver(pathExcelResource, strDriverName, TRUE)

       

      some code ' error happens before closing the driver

       

      Call DDT.CloseDriver(strDriverName)

       

      Regards,

      Jie

  • Ravik's avatar
    Ravik
    Super Contributor
    9 years ago

    Hi

     

    Try this simple code, it will close your all excel

     

     

    Sub CloseExcel

     

    Do whilen Sys.Process("EXCEL").Exists = True

     

       Sys.Process("EXCEL").Close

    Loop

     

    End Sub

     

    It is may help you.

    (In previous code you got error becouse, you may not may excel process in Name Mapping.)

    • xuerzj's avatar
      xuerzj
      New Contributor
      9 years ago

      Hi Ravik,

       

      I use the following command to create and close excel drivers. Sys.Process("EXCEL").Exists always return false.

       

      Set Driver = DDT.ExcelDriver(pathExcelResource, strDriverName, TRUE)

       

      some code ' error happens before closing the driver

       

      Call DDT.CloseDriver(strDriverName)

       

      Regards,

      Jie