Date to text

natexcel · Mar 12th, 2002, 08:11 AM

I have a date in cell C4 that i want to use to open a file from my floppy A drive. The date is in the format March 10, 2002. The filename is in the format __020310.asc. How can I use cell C4 to open this file?

Thanks in advance for the help.

Dave Hawley · Mar 12th, 2002, 08:21 AM

Hi NatExcel

Try

Dim strName As String
strName = Format(Sheet1.Range("C4"), "yymmdd")
MsgBox strName & ".file ext"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 12th, 2002, 08:11 AM	#1
natexcel New Member Join Date: Mar 2002 Posts: 15	I have a date in cell C4 that i want to use to open a file from my floppy A drive. The date is in the format March 10, 2002. The filename is in the format __020310.asc. How can I use cell C4 to open this file? Thanks in advance for the help.

Mar 12th, 2002, 08:21 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi NatExcel Try Dim strName As String strName = Format(Sheet1.Range("C4"), "yymmdd") MsgBox strName & ".file ext"