I want a task scheduler job written mostly in vba (any other scripting language will be ok) in windows that will close all open excel file. The catch is, currently i have a job that is doing the task properly. But it is unable to close an excel file if we get a dialog like save, do not save, cancel or excel file hangs.
Basically if you know, we can go to Start Task Manager and from that in the Processes tab we want to close all excel instances. This will resolve the issue. HOpe this is clear.
Basically a task schduler that will run couple of times a day and the task scheduler will close all the excel instances available in Processes tab of 'Start Task manager' option.