Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

How is possible to change "save as" date format to capital letters?

Posted on 2011-02-20
2
Medium Priority
?
255 Views
Last Modified: 2012-05-11
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
strDirname = "\" & Format(Date, "yyyy") & "\" & Format(Date, "mmm yyyy")

Open in new window

0
Comment
Question by:spar-kle
2 Comments
 
LVL 50

Accepted Solution

by:
Dave Brett earned 2000 total points
ID: 34939249
hth

strDirname = UCase$("\" & Format(Date, "yyyy") & "\" & Format(Date, "mmm yyyy"))

Open in new window

0
 

Author Closing Comment

by:spar-kle
ID: 34939281
Thanks Dave
I knew it would be easy, played aound with UCASE but couldn't figure it out.
Des
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa‚Ķ

572 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question