Forum Discussion
Ravik
Super Contributor
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
9 years agoNew Contributor
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
Related Content
- 8 months agoḼari
Recent Discussions
- 9 hours agod_gfleetwood92
- 10 hours agoFFCB