RE: [Talk] Adding Date&Time to file name to make unique

[McClain, Jeff]

This is what I have used in some of my scripts:   Dim newname As String newname = [Filename] + Format(Date, "mmddyy") + "-" + Format(Time, "hhmmss") + ".txt"   Jeff McClain Memorial Hospital 1101 Michigan Avenue Logansport, IN  46947 Ph:  (574) 753-1732 Fax: (574) 753-1451 Email: [EMAIL PROTECTED]    -----Original Message----- From: Pickersgill Jeff [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 3:41 PM To: TALK BWS (E-mail) Subject: [Talk] Adding Date&Time to file name to make unique Hi All  I am wondering if anyone has a VBcode snippet and/or instructions to add a date and time string to an existing file name to ensure uniqueness after saving. Thanks Jeff Jeff Pickersgill ART, MLT LIS Coordinator Hamilton Regional Laboratory Medicine Program General Hospital Site LIS Services - Room 1-180G   �  [EMAIL PROTECTED] ' 905.521.9800 ext. 74675 �   905.577.8027 �  905.972.5005 "  www.hamiltonhealthsciences.ca       This information is directed in confidence solely to the person named above and may not otherwise be distributed, copied or disclosed. Therefore, this information should be considered strictly confidential. If you have received this email in error, please notify the sender immediately via a return email for further direction. Thank you for your assistance.