LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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 -


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Workbook access counter in excel? basher57 Excel Discussion (Misc queries) 1 January 30th 07 09:30 PM
Reset Counter Ed Excel Discussion (Misc queries) 3 April 14th 06 05:35 PM
Reset alerts when closing workbook? Brian Delaney Excel Programming 3 August 21st 05 03:41 PM
How reset margins in Excel workbook? KYgirl Excel Discussion (Misc queries) 1 April 29th 05 12:52 AM
Counter does not reset, on 2nd trial Milind Excel Programming 0 August 4th 03 09:50 PM


All times are GMT +1. The time now is 07:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"