Building Excel Real-Time Data Components in Visual Basic .NET

[DavidD]

I followed the instructions here to build an Excel RTD server:

http://msdn2.microsoft.com/en-us/lib...ffice.10).aspx

This works fine on XP but crashes (very badly) in Vista. When the
Timer expires (and calls m_xlRTDUpdate.UpdateNotify()) I get the scary
exception:

Unable to cast COM object of type 'System.__ComObject' to interface
type 'Microsoft.Office.Interop.Excel.IRTDUpdateEvent'. This operation
failed because the QueryInterface call on the COM component for the
interface with IID '{A43788C1-D91B-11D3-8F39-00C04F3651B8}' failed due
to the following error: No such interface supported (Exception from
HRESULT: 0x80004002 (E_NOINTERFACE)).

I don't know what else to provide except that I've tried everything
(including different threads, threading models, singletons, etc).

Any ideas?

Thanks,

David Demner