How to Reset Workbook Counter?

  • Thread starter Thread starter Joseph Geretz
  • Start date Start date
J

Joseph Geretz

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 -
 
Can you simply restart Excel every so often? First thing in the
morning, every Monday morning, something like that?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reset workbook counter to "0" 4
reseting hidden shape counter 1
Resetting an object counter 6
How to bypass password when pasting FROM a protected workbook 3
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Copy cell change to other workbook 5
Copy Worksheets To New Workbook 2
Excel in Perl VIA OLE -- saving workbook(s) 2

Back
Top