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 ...
leandroaraujoso's avatar
leandroaraujoso
Contributor
11 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
11 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