| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Date Issue
Thanks Mike!
"Mike H" wrote in message ... Hi, One way is to create a table of French month names and their English translation. In this example I use A1 - B12 but in practice it could be anywhere out of the way. strLastMonth = WorksheetFunction.VLookup(Format(DateAdd("m", -1, Date), _ "mmmm"), Sheets("Sheet1").Range("A1:B12"), 2, False) Mike "Redan" wrote: Hi, I am using Excel 2007 on PC running Windows Vista Ultimate (in french) and I'd like to return the last month in english instead of french. strLastMonth = Format(DateAdd("m", -1, Date), "mmmm") When running the code below, I get "octobre" (in french) and I want to get "october" no matter what is the language of the pc I'm running my excel sheet on. Thanks in advance! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2000 vs 2003 date issue | Excel Programming | |||
| Date Issue with Microsoft Excel | Excel Discussion (Misc queries) | |||
| Date Issue in excel vba | Excel Programming | |||
| Excel date format issue | Excel Discussion (Misc queries) | |||
| Excel 2003: date display issue | Excel Discussion (Misc queries) | |||
Hybrid Mode
