View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Torben Laursen[_3_] Torben Laursen[_3_] is offline
external usenet poster
 
Posts: 8
Default C# COM in Excel: Avoid using Marshal

I often get a "Operation unavailable (Exception from HRESULT: 0x800401E3
(MK_E_UNAVAILABLE))"
Error in Excel when I try to call my UDF in a save sheet.

If I waite a few seconds the error goes away and everything works fine.

The error comes from this line of code:
App = (MSExcel.Application)Marshal.GetActiveObject("Exce l.Application");

Where App is defined as

private MSExcel.Application App;

I read that I get a reference to Excel in the OnConnection function inside
the Connect class.

But how do I use that reference inside my UDF's?

Torben