From: Torben Laursen on 23 Mar 2007 09:13
I often get a "Operation unavailable (Exception from HRESULT: 0x800401E3
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?
Prev: Can macros be viewed or edited while in shared mode in Excel 2007?
Next: crash on close