Your welcome

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"AH·C" wrote in message
...

Paul, I do use the DATE technique on other files, particularly on my
personal work records & timeshetts etc.

However, this project is a template used by 10 inspectors daily, but
after a few days, the typical Job# gets closed, while some may stay
open up to 1/2 year. On average, we'll have about 100 active job
orders.

Hmmm, thinking about the pros/cons of the end result... in terms of
backup, 'paper-trail' and saving to network server, etc... yes, I will
go with "yymmddhhmm" (no sorting issues).

Certainly eliminates the issue of me manually renaming & uploading the
files after the net goes down for whatever reason or when an inspector
comes back in wireless range.

Thanks for the thot stimulation, your suggestion is indeed a TIME
saver. ;)

Andy


--
AH·C
------------------------------------------------------------------------
AH·C's Profile:
http://www.excelforum.com/member.php...o&userid=29108
View this thread: http://www.excelforum.com/showthread...hreadid=488537