Thread: VBA, How to open a file with date like 29 August 2004
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default 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/



Reply With QuoteReply With Quote