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, "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