Prev: Can macros be viewed or edited while in shared mode in Excel 2007?
Next: crash on close
From: Torben Laursen on 23 Mar 2007 09:13
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("Excel.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








 | 
Pages: 1
Prev: Can macros be viewed or edited while in shared mode in Excel 2007?
Next: crash on close