Old format or invalid type library - Excel with non-English region

[Dan Glyde]

We currently have an application written with Visual Basic 2005. This
application makes reference to the Excel object and has the ability to launch
worksheets and insert data into cells, etc. We have recently rolled this
application out to European non-English speaking countries and have found a
problem with calling the excel object to create worksheets, etc. when the
windows regional settings is set to something other than English, but the
version of Excel is English. We have found a posted work around at:
http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q320369& and have
applied it. This however seems to solve only part of our problem. Before
applying this fix we could not even launch excel if the Windows regional
settings were set to something other than English (say German for example)
and the version of Excel was an English version. After applying this fix we
found that we could launch excel once more, but found that a large number of
other interactive functions would not work. Setting properties like
ExcelSheet.Visible, ExcelApplication.DisplayAllerts,
ExcelApplication.ScreenUpdating and calling functions like
ExcelSheet.Activate() and ExcelBook.Activate() cause the error “Old format
or invalid type libraryâ€. We have Microsoft Office 2003 Professional
Enterprise Edition installed, and this is what our application is compiled
with. Without being able to set these properties and call these functions,
our application does not run properly and we encounter a lot of strange
behavior. Any help with any workarounds or code changes would be greatly
appreciated.

 

[David Thielen]

Read the post 3 before this about the Multilanguage User Interface
Pack (?) - the links in that tell you what is going on.

thanks - dave


On Tue, 23 Sep 2008 06:43:01 -0700, Dan Glyde <Dan

We currently have an application written with Visual Basic 2005. This
application makes reference to the Excel object and has the ability to launch
worksheets and insert data into cells, etc. We have recently rolled this
application out to European non-English speaking countries and have found a
problem with calling the excel object to create worksheets, etc. when the
windows regional settings is set to something other than English, but the
version of Excel is English. We have found a posted work around at:
http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q320369& and have
applied it. This however seems to solve only part of our problem. Before
applying this fix we could not even launch excel if the Windows regional
settings were set to something other than English (say German for example)
and the version of Excel was an English version. After applying this fix we
found that we could launch excel once more, but found that a large number of
other interactive functions would not work. Setting properties like
ExcelSheet.Visible, ExcelApplication.DisplayAllerts,
ExcelApplication.ScreenUpdating and calling functions like
ExcelSheet.Activate() and ExcelBook.Activate() cause the error “Old format
or invalid type library”. We have Microsoft Office 2003 Professional
Enterprise Edition installed, and this is what our application is compiled
with. Without being able to set these properties and call these functions,
our application does not run properly and we encounter a lot of strange
behavior. Any help with any workarounds or code changes would be greatly
appreciated.

david@[email protected]
Windward Reports -- http://www.WindwardReports.com
me -- http://dave.thielen.com

Cubicle Wars - http://www.windwardreports.com/film.htm

 

[Vinod Lewis]

I am getting the same error "Old format or invalid type library"

I just want to know how to use / create bulleted point no. 2 and 3

I mean to say:

- Execute the Excel method or property by using InvokeMember
or

- set the CultureInfo prior to calling the Excel method

Any help is greatly appreciated.

Regards,
Lewis