Hi,


I'd like to open a file saved each day like that :

27 August 2004.txt
28 August 2004.txt
29 August 2004.txt

etc.

Unfortunately I don't know how to do that in VBA.
I could open the file if the name was for instance 20040728 using thi
code Format(Now(), "yyyymmdd") but I have no idea how to do that wit
the date like 28 August 2004

Any idea ?

Thank you in advance,

Gre

--
Message posted from http://www.ExcelForum.com