Forum Discussion

xuerzj's avatar
xuerzj
New Contributor
11 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
11 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
11 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