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

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

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

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

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

--
Regards,
Tom Ogilvy


"Grek " wrote in message
...
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 this
code Format(Now(), "yyyymmdd") but I have no idea how to do that with
the date like 28 August 2004

Any idea ?

Thank you in advance,

Greg


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

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

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

Thanks again,

Gre

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