There may be a handful of Excel Workbooks and specific sheets that may be opened by either manual folks or a broken automation script.

Is there a way to find out which workbooks are open? Is there a way to ask the OS or someplace else what specific books are open and if these books have specific sheets open?

I don't want to kill any process that is Excel. Only certain ones.

Is there a way to tell what books are open?