Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Insert auto serial number in Excel template

I don't now how to insert new auto serial number or couter every time when
the template is opened
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 441
Default Insert auto serial number in Excel template

Hi,

What I did once was similar, check out "CustomDocumentProperties". You can
add a "Serial number" property there and most users aren't even aware of it.
It can be installed and retrieved in code automatically, but you would need
to store some type of counter in your program file.

Custom document properties are visible by going to [File] then [Properties]
then click on the [Custom] tab. You can write auto-open event code to
increment a counter, version number or whatever.

Hope this helps.

"Van Gel" wrote:

I don't now how to insert new auto serial number or couter every time when
the template is opened

Reply
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
how do i use the daye function to insert a serial number stephanieylalo New Users to Excel 2 February 20th 10 04:03 PM
macro to add an auto serial number column Blubber Excel Discussion (Misc queries) 3 October 24th 08 09:36 AM
How do I auto number cells in an Excel template? Natalie Excel Discussion (Misc queries) 3 March 30th 05 03:42 AM
Auto insert a number of rows Gar3th Excel Programming 0 January 11th 05 08:21 PM


All times are GMT +1. The time now is 04:47 AM.

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

About Us

"It's about Microsoft Excel"