Contributions
Re: Is there a way to close all open excel drivers?
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 happensbefore closing the driver Call DDT.CloseDriver(strDriverName) Regards, Jie2.4KViews0likes0CommentsRe: Is there a way to close all open excel drivers?
HiLeandro, 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 happensbefore closing the driver Call DDT.CloseDriver(strDriverName) Regards, Jie2.5KViews0likes0CommentsIs 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 file which is for the previoustest. How should I handle this situation? Is there a way to check if there are open excel drivers and close them? I may needto put the check in Event Handler onlogerror. Thank you.2.5KViews0likes7Comments