Excel 97/XP Issue with numbers and French machines

[godburger]

Hi folks,

I was wondering if someone could provide a little input...

I have an excel application which is set up as follows...

An english workbook.
A french workbook.
A neutral workbook which contains worksheets full of number fields.

Both the english and the french workbooks perform the same
functionality, and incorporate VBA. They both also open up and link to
the neutral workbook. All workbooks were developed on an english
machine.

Due to issues with the french book thinking that the neutral book
contains text values instead of numeric values, I had to code a
procedure to parse through the value; check and see if the correct
decimal seperator is being used; replace it with the correct one if it
is not; and then convert the value to a double.

This works fine in 97. However, this application is used by both 97/XP
on french machines. A SUM function on the 97 version works fine, and
provides the expected result of 0...on an XP machine using the same
test case it provides a result of -1282791,9872.

Has anybody had an experience similar to this? I've been scouring the
posts for something similar. I seem to recall one article mentioned
something about the XP system thinking that the new number was a time.

Has anyone else had any similar experiences?

 

[Carlos Lozano]

Hi,

I know there are many issues when switching languages and locals as some use
the Engish system others the International System besides using the ","
instead ".", etc.
One thing you can try is adding to your application code to check it and set
the right format when activating the workbook.

Read:
http://support.microsoft.com/default.aspx?scid=kb;en-us;170550

http://msdn.microsoft.com/library/d...axl11/html/xlproInternational1_HV05202184.asp

http://support.microsoft.com/default.aspx?scid=kb;en-us;111388

Look in the KB for more information.

Hope this helps.

Carlos Lozano
www.caxonline.net