How to Reset Workbook Counter?
 

How do I reset the Workbook counter? We are using an Excel Application
programmatically for the purpose of displaying worksheets. We keep the Excel
Application loaded between worksheets for performance purposes, although
naturally we are closing and opening workbooks all day long. I'm noticing
that the Workbook number keeps increasing though, which concerns me. Nothing
can keep increasing forever, without causing a problem sooner or later. How
can I direct my Excel Application to reset its workbook counter to the
lowest available number, each time it opens a new workbook?

Thanks for your help!

- Joe Geretz -

How to Reset Workbook Counter?
 

Can you simply restart Excel every so often? First thing in the
morning, every Monday morning, something like that?