Insert auto serial number in Excel template

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I don't now how to insert new auto serial number or couter every time when
the template is opened
 
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.
 

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

Back
Top