View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Joseph Geretz Joseph Geretz is offline
external usenet poster
 
Posts: 32
Default 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 -