Error: type library error: type name not unique

[koukie]

Error in ExcelSheet.: type library error: type name not unique (Application).

Hi, I am getting the above error when using outlook typelib ver 9.2, and then using ExcelSheet class afterwards. If I exit QM or wait for a while, ExcelSheet class will function as normal. Sometimes it gives me an error and other times it doesn't. Error points me to the private function ExcelSheet. where !ws is.

Code:

Copy      Help

if(ws and !ws.Application.UserControl)
    Excel.Workbook wb=ws.Parent; err
    wb.Saved=TRUE; err
    ws.Application.Quit
err+

[Gintaras]

Bug. Workaround - use ExcelSheet before Outlook.Application.

Code:

Copy      Help

ExcelSheet es
;...
Outlook.Application oa

or insert

Excel.Application ea

before ExcelSheet. Here ea is used just for Excel.Application declaration.

[koukie]

excellent... seems to work for now. will look more into it. thanks.