Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Multiple Languages | Excel Discussion (Misc queries) | |||
different languages | Excel Discussion (Misc queries) | |||
Is there a table of Excel function-names for different languages? | Excel Discussion (Misc queries) | |||
How do you display Greek and Russian languages in excel? | Excel Discussion (Misc queries) | |||
Read unicode (Asian Languages) from Excel spreadsheet | Excel Programming |