Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i use the daye function to insert a serial number | New Users to Excel | |||
macro to add an auto serial number column | Excel Discussion (Misc queries) | |||
How do I auto number cells in an Excel template? | Excel Discussion (Misc queries) | |||
Auto insert a number of rows | Excel Programming |