LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default How to get the available languages (MUI) of Excel using VBA?

I wrote a C# application that inserts data to a Workbook using VBA.

The program worked fine on my PC but caused the "Old format or invalid
type library" exception on another person's PC. The person was using
English version of Excel and Windows, but had set the regional format
to Korean. I have read some articles about this problem on MSDN, and
found causes and solutions. It happens when Excel does not have the
MUI (Multilingual User Interface) for the language that the
application is using. That is, my C# application was using Korean
culture because it was the system's regional format, but the English
version of Excel did not have Korean MUI.

There was a solution. I forced the culture to be "en-US" and it worked
OK. But come to think of it, what if the user "has" Korean MUI? It
does not seem to be right to force "en-US" every time when I don't
have to. So the question is, who do I know if the Excel has the MUI
for the language which is the system's default regional format? Is
there any way to get the list of MUI languages that Excel has on a
particular system using VBA?

A dirty solution could be first trying to insert some data to Excel,
then if "Old format or invalid type library" happens then forcing the
language to be "en-US". But it really seems to be dirty.
 
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
Multiple Languages Infexus Bytez Excel Discussion (Misc queries) 1 March 30th 10 05:18 PM
different languages Matt Excel Discussion (Misc queries) 0 June 19th 07 03:36 PM
Is there a table of Excel function-names for different languages? Julia.P999 Excel Discussion (Misc queries) 5 May 22nd 07 04:32 PM
How do you display Greek and Russian languages in excel? Mark Hayden Excel Discussion (Misc queries) 1 August 1st 05 08:06 AM
Read unicode (Asian Languages) from Excel spreadsheet Frank Excel Programming 1 May 3rd 05 03:23 AM


All times are GMT +1. The time now is 09:49 PM.

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

About Us

"It's about Microsoft Excel"