M
MB Blackburn
hello,
i am uncertain about where to post this but here goes anyway...i can't find
any VBA groups.
i have an ATL component with mostly IUnknown interfaces but also a few
IDispatch interfaces as well.
the IUnknown interfaces were developed first and tested.
then IDispatch versions were exposed later when Dumb Clients became a
possibility.
the IDispatch interfaces are marked as default in the IDL file.
Eventually i'd like LabView (a popular scientific program used to get data
from instruments) to use the component and it uses IDispatch only. however,
i don't have LabView installed.
however, i do have Excel97.
i decided *it* could serve as the quintessential dumb client.
So i wrote with VBA code calling my component's IDispatch interfaces.
What I have recently observed leads me to believe that Excel may be able to
make calls on IUnknown interfaces.
q1. is it true that VBA code (in Excel or any other office product like
Word) can talk to COM objects only on IDispatch interfaces?
q2. is it true that Excel can be accessed as a COM server only via an
IDispatch interface?
thanks,
m blackburn
i am uncertain about where to post this but here goes anyway...i can't find
any VBA groups.
i have an ATL component with mostly IUnknown interfaces but also a few
IDispatch interfaces as well.
the IUnknown interfaces were developed first and tested.
then IDispatch versions were exposed later when Dumb Clients became a
possibility.
the IDispatch interfaces are marked as default in the IDL file.
Eventually i'd like LabView (a popular scientific program used to get data
from instruments) to use the component and it uses IDispatch only. however,
i don't have LabView installed.
however, i do have Excel97.
i decided *it* could serve as the quintessential dumb client.
So i wrote with VBA code calling my component's IDispatch interfaces.
What I have recently observed leads me to believe that Excel may be able to
make calls on IUnknown interfaces.
q1. is it true that VBA code (in Excel or any other office product like
Word) can talk to COM objects only on IDispatch interfaces?
q2. is it true that Excel can be accessed as a COM server only via an
IDispatch interface?
thanks,
m blackburn