Running in Excel 2007 with culture zh-Ch.

I create an Excel button from my COM C# add-in using _combo =
worksheet.Shapes.AddFormControl(Excel.XlFormContro l.xlButtonControl, 0, 0, 0,
0);

This defaults to an English string name "Button 1".

When this button is clicked. It runs an action that is in a .xla Within this
..xla application.Caller is a string that is the Chinese equivalent to "Button
1".

The xla calls back into the C# add-in and using the Excel applications
object I call get_Caller(System.Missing). This also returns the button name
in Chinese.

How can I ensure these are in a consistent culture?

--
EB

if I assign the Shape a name other than some form of "Button 1", "Button 1"
( notice extra space) , Excel will return the English version

Excel.Shape shape;

// create shape

shape = Worksheet.Shapes.AddFormControl ....
shape.Name = "BUTTON1"; // returns as is
= "Button 2"; // returns as is
= "dog"; // returns as is
= "Button 1" // translated

I could hypothesize on key word is "Button" for Shapes or maybe because I
used xlButtonControl, "1" is the count or id used by Excel.


--
EB


"EBenson" wrote:

Running in Excel 2007 with culture zh-Ch.

I create an Excel button from my COM C# add-in using _combo =
worksheet.Shapes.AddFormControl(Excel.XlFormContro l.xlButtonControl, 0, 0, 0,
0);

This defaults to an English string name "Button 1".

When this button is clicked. It runs an action that is in a .xla Within this
.xla application.Caller is a string that is the Chinese equivalent to "Button
1".

The xla calls back into the C# add-in and using the Excel applications
object I call get_Caller(System.Missing). This also returns the button name
in Chinese.

How can I ensure these are in a consistent culture?

--
EB