With this code i can load a file called "180704 AB.xls".


= Format(Date, "ddmmyy") & " AB.xls"


But what i want to do is load a file with a month prefix.
e.g "July 2004 AB.xls".

Could someone please tell me how i could do this in VBA.

Many thanks

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

Format(Date, "mmm yyyy") & " AB.xls"


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Jako " wrote in message
...
With this code i can load a file called "180704 AB.xls".


= Format(Date, "ddmmyy") & " AB.xls"


But what i want to do is load a file with a month prefix.
e.g "July 2004 AB.xls".

Could someone please tell me how i could do this in VBA.

Many thanks.


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