Date formatting a file

  • Thread starter Thread starter Jako
  • Start date Start date
J

Jako

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
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to load these XLS files 5
Is it possible to load an .xls file 2
Date as worksheet name 2
[Help!] CSV(s) --> xls 1
Formatting date 3
Detecting date format 1
Date formatting in VBA 1
Suggest a file name OnSave 2

Back
Top