Open text file based on date.

[Dan Jordan]

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

 

[Ron de Bruin]

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

 

[Dan Jordan]

Thanks Ron!! worked perfect

Dan