Open text file based on date.
 

I am in need of a way to open a text file based on the
date in a worksheet.
I have many text files saved as ST20061007.txt , ST20061006.txt ect. all
files start with ST then the
date. I need to be able to open each file based on
a date inputted into another cell in the workbook,
So if a user enters 10/6/2006 then it would open
the file ST20061006.txt.

Any help would be Great.

Dan

*** Sent via Developersdex http://www.developersdex.com ***

Open text file based on date.
 

Hi Dan

You can try this with the date in A1 it open the file that is in C:\

Workbooks.OpenText "C:\ST" & Format(Range("A1"), "yyyymmdd") & ".txt", Origin:=xlWindows

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Dan Jordan" wrote in message ...
I am in need of a way to open a text file based on the
date in a worksheet.
I have many text files saved as ST20061007.txt , ST20061006.txt ect. all
files start with ST then the
date. I need to be able to open each file based on
a date inputted into another cell in the workbook,
So if a user enters 10/6/2006 then it would open
the file ST20061006.txt.

Any help would be Great.

Dan

*** Sent via Developersdex http://www.developersdex.com ***

Open text file based on date.
 

Thanks Ron!! worked perfect

Dan

*** Sent via Developersdex http://www.developersdex.com ***