We have VBA Macro in which we are using constants
min = 0.5
max = 0.999

If the locale is US[English] the macro code work fine with these
constants

If the code is used in Europe which has a differnt locale
which represent "decimal symbol = , ". So in the macro code
the decimal is getting dropped.

min = 5
max = 999

Is there a way to fix this problem without much modifying the code as
these constant are scattered accorss the code?

Thanks in advance.


--
iamrajy
------------------------------------------------------------------------
iamrajy's Profile: http://www.excelforum.com/member.php...o&userid=28117
View this thread: http://www.excelforum.com/showthread...hreadid=476247

--
iamrajy
------------------------------------------------------------------------
iamrajy's Profile: http://www.excelforum.com/member.php...o&userid=28117
View this thread: http://www.excelforum.com/showthread...hreadid=476247

Public Const sglMIN As Single = 0.5

declared at the top of a vba module should work in any regional version of
excel after xl95.

--
Regards,
Tom Ogilvy



"iamrajy" wrote in
message ...

We have VBA Macro in which we are using constants
min = 0.5
max = 0.999

If the locale is US[English] the macro code work fine with these
constants

If the code is used in Europe which has a differnt locale
which represent "decimal symbol = , ". So in the macro code
the decimal is getting dropped.

min = 5
max = 999

Is there a way to fix this problem without much modifying the code as
these constant are scattered accorss the code?

Thanks in advance.


--
iamrajy
------------------------------------------------------------------------
iamrajy's Profile:
http://www.excelforum.com/member.php...o&userid=28117
View this thread: http://www.excelforum.com/showthread...hreadid=476247

Thanks for your advise.

We have defined the bounds/variable related to columns in xml

e.g.

s_currentEntityXmlText = s_currentEntityXmlText & " <field
name=""STK_SRV_LEVEL"" fieldOrderNum=""17"" excelDataType=""Single""
required=""true"" excelLower=""0.5"" excelLowerExclusive=""false""
excelUpper=""0.999"" excelUpperExclusive=""false"" /"

In the macro we extract the value of excelLower and excelUpper and
there we get a problem when locale is not "United State"

In European locale the value get changed to 5 and 999

Any suggestion


--
iamrajy
------------------------------------------------------------------------
iamrajy's Profile: http://www.excelforum.com/member.php...o&userid=28117
View this thread: http://www.excelforum.com/showthread...hreadid=476247