Excel Export Error

[cland410]

Hey guys,

I work for a software development company and we are working on an Excel export feature. Our company does a lot with internationalization and we believe the following error is happening because of this. In the code, when we are attempting to save the workbook and we get the following runtime error: “Old format or invalid type library. (Exception from HRESULT: 0x80028018 (TYPE_E_INVDATAREAD))”. We only receive this error when the Windows Region and Language Format is set to one other than English (United States), for example Czech (Czech Republic), when the format is set to English it works fine. We are using Windows 7 (but not sure if that will make a difference).

Thank You,

Cory

[SalmanShakeel]

Hi Cory,

We are working on the issue mentioned by you. The issue has been logged into our Issue Tracking System with ID CELLSNET-20061. We will update you as soon as possible with the solution.

Thanks,

[SalmanShakeel]

Hi Cory,

After working on this issue, wee are unable to reproduce the issue. It all worked find if we set language of the machine as Czech. For further investigation, please send us your sample porject as well as the Excel file.

Thanks,

[cland410]

We were working on designing a small project for you, but while doing so, found the problem which was not how we saved the workbook but how we were attempting to open it. We changed the original code:

Dim myExcel As New Object

myExcel = CreateObject(“Excel.Application”)

myExcel.Interactive = True

myExcel.Visible = True

myExcel.Application.Workbooks.Open(FileName)

myExcel = Nothing

to:

PlatformAPI.ShellExecute(“explorer.exe “”” + FileName + “”"", AppWinStyle.NormalFocus, False)

and we did not get that error anymore. Thank you for your help!