View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Daniel[_15_] Daniel[_15_] is offline
external usenet poster
 
Posts: 2
Default Excel2003 and xlListSeparator...

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.
XX ( remove the XX ).