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

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

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