VBA, How to open a file with date like 29 August 2004

[Grek]

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

 

[Tom Ogilvy]

Format(Now(), "dd mmmm yyyy")

? Format(Now(), "dd mmmm yyyy")
29 August 2004

 

[Grek]

Thanks a lot !
I was sure "mmmm" would'nt work so I didn't even try.
I was wrong ;-)

Thanks again,

Gre