Thread: Locale problem
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
iamrajy[_3_] iamrajy[_3_] is offline
external usenet poster
 
Posts: 1
Default Locale problem


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