Try: filename = "MyFile" & format(now(),"yyyymmddhhmmss") & ".txt"
> -----Original Message----- > From: Pickersgill Jeff [SMTP:[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] <mailto:[EMAIL PROTECTED]> > '*905.521.9800 ext. 74675 > * * 905.577.8027 > ***905.972.5005 > "* www.hamiltonhealthsciences.ca <http://www.hamiltonhealthsciences.ca/> > > > > > _____ > > Upgrade Your Email - Click here! > <http://promos.hotbar.com/promos/promodll.dll?RunPromo&El=hotbar%5felement > %3bst%3b&SG=&RAND=65209&partner=hotbar> > > > 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. > > > **************************************************************************** ******************************************** Satilla Health Services advises the recipient that this electronic message is intended only for the individual or entity to which it is addressed and may contain information that is confidential and protected by law. If you are not the intended recipient of this e-mail, you are cautioned that the use of its contents in any way is prohibited and may be unlawful. If you have received this communication in error, please notify the sender immediately by e-mail or telephone and return the original message by e-mail to the sender. We will reimburse you for any cost you incur in notifying us of the errant e-mail. *****
