| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Name of month
I am making a macro that generates a report. I want to set the title of the
report to the current month. I dont quite know how to use the now property (my help fuunction does not work). Code: strDate1 = Format(Now, "YYYY-MM-DD") with this I get the month (and day etc.) but I want to get the month and be able to show it in a cell. How do you do this? Is it possible to the month in another language? (my excel is in swedish and I wantb to get in swedish). Please help me! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count month when date is in day/month/year format | Excel Worksheet Functions | |||
| excel to make the days cary over month to month automaticly | New Users to Excel | |||
| Excel 2003 month to month data change grid | Excel Discussion (Misc queries) | |||
| copy worksheet from previous month and rename to current month | Excel Programming | |||
| transfer cell $ amount to other sheet month-to-month without overc | Excel Discussion (Misc queries) | |||
Threaded Mode
