Re: Converting frrom Office 2000 to Office XP

[Frank Sylvestro <sylvestro@COMCAST.NET>]

Damon,
Thank you for the reply.  Since you were able to get it to work, I started
to think outside of the box.  I then realized the complier was looking for a
reference that was not installed on the computer running Office XP.  Once I
removed that reference, it worked fine.

Thank you for your support.

Frank

----- Original Message -----
From: "Longworth, Damon" <dlongworth@LAKEREGIONAL.COM>
To: <EXCEL-G@PEACH.EASE.LSOFT.COM>
Sent: Friday, July 25, 2003 9:30 AM
Subject: Re: Converting frrom Office 2000 to Office XP


> 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

--------------------------------------------------------------------------
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