spar-kle
asked on
How is possible to change "save as" date format to capital letters?
I use the attached code in a "save as" macro.
How should I change it so that the month format is in capital letters
ie "\2011\FEB 2011" instead of "\2011\Feb 2011"
Thanks for your help
Des
How should I change it so that the month format is in capital letters
ie "\2011\FEB 2011" instead of "\2011\Feb 2011"
Thanks for your help
Des
strDirname = "\" & Format(Date, "yyyy") & "\" & Format(Date, "mmm yyyy")
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I knew it would be easy, played aound with UCASE but couldn't figure it out.
Des