xuerzj
New Contributor
Joined 11 years ago
User Profile
User Widgets
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 happens before closing the driver Call DDT.CloseDriver(strDriverName) Regards, Jie2.4KViews0likes0CommentsRe: Is there a way to close all open excel drivers?
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, 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 previous test. How should I handle this situation? Is there a way to check if there are open excel drivers and close them? I may need to put the check in Event Handler onlogerror. Thank you.2.5KViews0likes7Comments