Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. XL2000: COM Add-in Ignores Regional Settings When Creating Data Validation in Excel

XL2000: COM Add-in Ignores Regional Settings When Creating Data Validation in Excel

View products that this article applies to.

This article was previously published under Q302754

↑ Back to the top

Symptoms

When you use a Component Object Model (COM) add-in to automate the process of creating a data validation range in an Excel workbook, text in the input message does not use the applied list separator under Regional Settings in Control Panel.

↑ Back to the top

Cause

COM add-ins interact with Excel through a different part of the object model that does not support a Locale ID (LCID). Because COM Add-ins do not have a Locale ID passed to them, the default language setting that they use is English U.S.

↑ Back to the top

Workaround

To work around this behavior, you can use a .xla file (Excel add-in) instead of a COM add-in.

↑ Back to the top

Keywords: KB302754, kbprb

↑ Back to the top

Article Info
Article ID : 302754
Revision : 4
Created on : 1/6/2006
Published on : 1/6/2006
Exists online : False
Views : 219