OnCalculate and such events, as found in the Application interface of Excel. Using C++ for automatio

[Sean Van Buggenum]

Hi all,

I have been writing a program that controls excel from another process.
I can use those events provided through the AppEvents interface, and other
interfaces like these, but for those call backs like OnCalculate (which is
found only in the interface _Application ).

How do you use these functions as callback in C++ ? When i set this up it
seems simply to want to call a macro on the Excel process. How do i set this
up ??? is it possible ?? has anyone done this ??

the .idl created through OleView shows this for interface _Application

interface _Application : IDispatch {
....
....
[id(0x00000271), propput, hidden, helpcontext(0x00010271)]
HRESULT OnCalculate(
[in, lcid] long lcid,
[in] BSTR RHS);
....
....

Any help for this will be very much appreciated. Thanks.