Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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 ).



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
excel2003 archie Charts and Charting in Excel 1 May 28th 10 01:38 PM
i want to know formulas in MS-Excel2003 MK Excel Discussion (Misc queries) 3 April 7th 10 08:17 PM
Excel2003 MAX and MIN with < hamricka[_3_] Excel Worksheet Functions 10 August 20th 09 04:06 PM
Excel2003 from Excel97 JohnL Excel Discussion (Misc queries) 3 April 15th 05 11:41 PM
Excel2003 and xlListSeparator... Microsoft Excel Programming 0 September 21st 04 09:59 AM


All times are GMT +1. The time now is 06:34 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"