Excel2003 and xlListSeparator...

[Daniel]

Hi,

I've an application that uses Excel from COM. It worked well with
Office2000 & XP, but breaks in Office2003. I use something like

range.formula = "=VLOOKUP($A21,Lines!1:65536,22,FALSE)";

from ( C++ ) to do lookups. This is with Regional Settings set to US English
and therefore list separator = comma. When the list separator is simi-colon
it breaks. Excel uses the simi-colon in formula entry, GetFormula() shows
the simi-colons, and Application.International(xlListSeparator) returns
simi-colon, but from COM only comma works in Office 2003. In earlier
versions only this had to be a simi-colon in this situation. Can anyone
confirm this ? Is this a defect or a permant change ?

Sincerely, Daniel von Tabouillot.
(e-mail address removed) ( remove the XX ).