Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 ). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel2003 | Charts and Charting in Excel | |||
i want to know formulas in MS-Excel2003 | Excel Discussion (Misc queries) | |||
Excel2003 MAX and MIN with < | Excel Worksheet Functions | |||
Excel2003 from Excel97 | Excel Discussion (Misc queries) | |||
Excel2003 and xlListSeparator... | Excel Programming |