Re: Converting frrom Office 2000 to Office XP

["Longworth, Damon" <dlongworth@LAKEREGIONAL.COM>]

The line works for me. I placed =Now() in a cell and then named it WEDate.
The string returned:

Timesheet 072503A

Damon Longworth
Lake Regional Health System
54 Hospital Dr.
Osage Beach, MO 65065
Tel. 573-348-8373 - Fax 573-348-8167
<mailto:dlongworth@lakeregional.com>


-----Original Message-----
From: Frank Sylvestro [mailto:sylvestro@COMCAST.NET]
Sent: Thursday, July 24, 2003 5:39 PM
To: EXCEL-G@PEACH.EASE.LSOFT.COM
Subject: Converting frrom Office 2000 to Office XP


Dear Excellers,
I need a little help with a piece of code.  Below is a line of code
which when ran in Office 2000 would result in pdfName equaling Timesheet
072503A

pdfName = "Timesheet " & Format(Range("WEDate").Value, "mmddyy") & "A"


Apparently some things have changed in office XP.  With the reading I
have done so far I have determined that I would need to use
"FormatDateTime"  I have tried and failed.  Can anyone using Office XP
rewrite the above line so I get the result that I would expect.



Frank



--------------------------------------------------------------------------
The EXCEL-G list is hosted on a Windows NT(TM) machine running L-Soft
international's LISTSERV(R) software.  For subscription/signoff info
and archives, see http://peach.ease.lsoft.com/archives/excel-g.html .
                             COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G


 This email originated from Lake Regional Health System. This email message,
including any attachments, contains confidential information which is
intended only for the use of the individual or entity named above.  If the
reader of this email is not the intended recipient or agent responsible for
delivering it to the intended recipient, he/she is hereby notified that you
are in possession of confidential and privileged information.  If you have
received this email in error, please notify the sender immediately. State
and federal law prohibits you from making further disclosure of this
information without specific written consent of the person to whom it
pertains, or as otherwise permitted by law.

--------------------------------------------------------------------------
The EXCEL-G list is hosted on a Windows NT(TM) machine running L-Soft
international's LISTSERV(R) software.  For subscription/signoff info
and archives, see http://peach.ease.lsoft.com/archives/excel-g.html .
                             COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G