Forum Discussion

xuerzj's avatar
xuerzj
New Contributor
10 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
10 years ago
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.