Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range names are created with the English format : for ex. _15_Feb_06
Hello,
I'm using Excel 2003 French version. In a spreadsheet, I have a serie of dates such as 1-févr-06; 15-févr-06; 1-mars-06; 15-mars-06... (with an abbreviation of the French months name) A VBA Sub creates range names by doing the equivalent of: Insert / Names / Create / Upper row. This sub worked fine in Excel 2000. In the 2003 version, all range names are created with the English format : for ex. _15_Feb_06 instead of _15_févr_06. Of course, the following sub doesn't find anything! How can I fix this issue? Thanks for your help Gérard |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range names are created with the English format : for ex. _15_Feb_06
Hi Gérard,
Please post the code of the Sub -- Kind regards, Niek Otten "Gérard Ducouret" wrote in message ... Hello, I'm using Excel 2003 French version. In a spreadsheet, I have a serie of dates such as 1-févr-06; 15-févr-06; 1-mars-06; 15-mars-06... (with an abbreviation of the French months name) A VBA Sub creates range names by doing the equivalent of: Insert / Names / Create / Upper row. This sub worked fine in Excel 2000. In the 2003 version, all range names are created with the English format : for ex. _15_Feb_06 instead of _15_févr_06. Of course, the following sub doesn't find anything! How can I fix this issue? Thanks for your help Gérard |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range names are created with the English format : for ex. _15_Feb_06
Hi Niek,
The code of the Sub is : Sub CréeNoms() Range("Angle").Select Range(Selection, Selection.End(xlToRight)).Select Range(Selection, Selection.End(xlDown)).Select Selection.CreateNames Top:=True, Left:=True, Bottom:=False, Right:=False End Sub NB : In the Control Panel, Regional Setting, Language, I have Français(France) When I do the operation manually, the months names are in French (such as _15_févr_06) When I run the Sub, they are created in English : _15_Feb_06 Thanks for your help, Gérard "Niek Otten" a écrit dans le message de ... Hi Gérard, Please post the code of the Sub -- Kind regards, Niek Otten "Gérard Ducouret" wrote in message ... Hello, I'm using Excel 2003 French version. In a spreadsheet, I have a serie of dates such as 1-févr-06; 15-févr-06; 1-mars-06; 15-mars-06... (with an abbreviation of the French months name) A VBA Sub creates range names by doing the equivalent of: Insert / Names / Create / Upper row. This sub worked fine in Excel 2000. In the 2003 version, all range names are created with the English format : for ex. _15_Feb_06 instead of _15_févr_06. Of course, the following sub doesn't find anything! How can I fix this issue? Thanks for your help Gérard |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using english and non-English Excel commands simultaneously in anon-English installation | Excel Worksheet Functions | |||
Excel 2007 not saving user-created range names | Excel Discussion (Misc queries) | |||
Worksheet created in French version doesn't work in English versio | Excel Discussion (Misc queries) | |||
copy range on every worksheet (diff names) to a master worksheet (to be created) | Excel Programming | |||
copy range on every worksheet (diff names) to a master worksheet (to be created) | Excel Programming |