Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Generate a unique form number
I am using Office 2003 on Windows XP.
I have a form built in Excel that will be placed in an Outlook folder making it accessible to all users within our organization. Each time a user opens this form a unique number must be generated on the form. Suppose I convert the Excel date to a value: e.g. Aug 17, 2005 becomes 38363 and for time I use 5:34:15 pm = 173415. Now suppose I add these two numbers together and also add the user's computer ID to this (each user must have a unique computer ID) for example: 83177. This would then be 38363 + 173415 + 83177 = 294955 Question: Since this value is date and time based and combines a unique computer ID, would this ALWAYS generate a unique six digit form number? The form number does need to be unique, but not necessarily in sequence Any one have any other suggestions? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I generate a unique reference number??? | Excel Discussion (Misc queries) | |||
How do I get a unique number on a form when I open it each time? | Excel Worksheet Functions | |||
How can I generate a unique number each time a form is printed? | Excel Worksheet Functions | |||
how to generate a unique form # when using an excel form template | Excel Worksheet Functions | |||
Generate number NOT using a form | New Users to Excel |