Converting frrom Office 2000 to Office XP

[Frank Sylvestro <sylvestro@COMCAST.NET>]

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