<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7651.59">
<TITLE>[python-win32] Passing Nothing into ReferencesEvents - resolved, however can't bind events</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/plain format -->
<P><FONT SIZE=2>Thanks for taking the time to answer, and for pywin. I've been using pywin with COM for some time, and am only now (when something doesn't "just work") starting to appreciate its internal complexities.<BR>
<BR>
I get back the following error:<BR>
>>> com_error: (-2147467262, 'No such interface supported', None, None)<BR>
I have a very sketchy understanding of COM's internals, but if the IDispatch interface was supported, wouldn't Dispatch() be using that?<BR>
Also, is there any way of getting the interfaces which an object does support?<BR>
<BR>
Thanks again,<BR>
Zev<BR>
<BR>
-----Original Message-----<BR>
From: Mark Hammond [<A HREF="mailto:mhammond@skippinet.com.au">mailto:mhammond@skippinet.com.au</A>]<BR>
Sent: Sat 10/17/2009 00:38<BR>
To: shivisi<BR>
Cc: python-win@python.org<BR>
Subject: Re: [python-win32] Passing Nothing into ReferencesEvents - resolved, however can't bind events<BR>
<BR>
Sorry, I did mislead you. After reading this in more detail your<BR>
initial code looked correct.<BR>
<BR>
Try something like:<BR>
<BR>
disp =<BR>
acc.VBE.Events.ReferencesEvents(None).QueryInterface(pythoncom.IID_IDispatch)<BR>
refsEvents=DispatchWithEvents(disp,RefEvents)<BR>
<BR>
To ensure we are passing an IDispatch rather than an IUnknown to<BR>
DispatchWithEvents.<BR>
<BR>
HTH,<BR>
<BR>
Mark<BR>
<BR>
<BR>
<BR>
On 16/10/2009 7:32 PM, shivisi wrote:<BR>
> I'm confused.<BR>
><BR>
> DispatchWithEvents fails on Access.Application, because there are no events on that object.<BR>
> The events of interest are on the associated VB Editor/VB Project, via the VBA Extensibility Library. VBE is the root object of that library, and that is the type of acc.VBE.<BR>
> These events are retrieved with the whole path:<BR>
>>>> acc.VBE.Events.ReferencesEvents(None)<BR>
> where acc is the Access.Application object.<BR>
><BR>
> If the Access.Application did have events, would win32com.PumpMessages() return events for all the child objects?<BR>
> If it does, then perhaps I can use:<BR>
>>>> DispatchWithEvents(acc.VBE.Events,RefEvents)<BR>
>>>> win32com.PumpMessages()<BR>
> However, ReferencesEvents is a "property with arguments", and needs to be passed None.<BR>
><BR>
> It seems that ReferencesEvents(None) returns a PyIUnknown object, and DispatchWithEvents can only bind to (at a minimum) PyIDispatch. Would comtypes help me here?<BR>
><BR>
> -----Original Message-----<BR>
> From: Mark Hammond [<A HREF="mailto:skippy.hammond@gmail.com">mailto:skippy.hammond@gmail.com</A>]<BR>
> Sent: Fri 10/16/2009 02:00<BR>
> To: shivisi<BR>
> Cc: python-win32@python.org<BR>
> Subject: Re: [python-win32] Passing Nothing into ReferencesEvents - resolved, however can't bind events<BR>
><BR>
> On 15/10/2009 10:50 PM, shivisi wrote:<BR>
>> Passing Application.VBE.Events.ReferencesEvents(None) works (at least at this point).<BR>
>> However, when I try to bind to an event class, I get the error below.<BR>
>> Any assistance, debugging suggestions, would be greatly appreciated.<BR>
>> Thanks.<BR>
>><BR>
>> # Code<BR>
>> from win32com.client import Dispatch, DispatchWithEvents, getevents<BR>
>><BR>
>> class RefEvents:<BR>
>> def OnItemAdded(self,ref):<BR>
>> print '--Event - Reference added'<BR>
>> def OnItemRemoved(self,ref):<BR>
>> print '--Event - Reference removed'<BR>
>><BR>
>> acc=Dispatch('Access.Application')<BR>
>> acc.Visible=True<BR>
>> refsEvents=DispatchWithEvents(acc.VBE.Events.ReferencesEvents(None),RefEvents)<BR>
><BR>
><BR>
> See the docstring for DispatchWithEvents - you probably want something<BR>
> closer to:<BR>
><BR>
> acc = DispatchWithEvents('Access.Application', RefEvents)<BR>
> acc.Visible = True<BR>
> win32com.PumpMessages() # sit here doing nothing but waiting for events...<BR>
><BR>
> Cheers,<BR>
><BR>
> Mark<BR>
><BR>
><BR>
>> #-----------------------------------------------------------------------------<BR>
>> Traceback (most recent call last):<BR>
>> File "<interactive input>", line 1, in<module><BR>
>> File "C:\Python26\lib\site-packages\win32com\client\__init__.py", line 245, in DispatchWithEvents<BR>
>> disp = Dispatch(clsid)<BR>
>> File "C:\Python26\lib\site-packages\win32com\client\__init__.py", line 96, in Dispatch<BR>
>> return __WrapDispatch(dispatch, userName, resultCLSID, typeinfo, clsctx=clsctx)<BR>
>> File "C:\Python26\lib\site-packages\win32com\client\__init__.py", line 43, in __WrapDispatch<BR>
>> return dynamic.Dispatch(dispatch, userName, WrapperClass, typeinfo, clsctx=clsctx)<BR>
>> File "C:\Python26\lib\site-packages\win32com\client\dynamic.py", line 118, in Dispatch<BR>
>> typeinfo = IDispatch.GetTypeInfo()<BR>
>> AttributeError: 'PyIUnknown' object has no attribute 'GetTypeInfo'<BR>
>> #-----------------------------------------------------------------------------<BR>
>>>>> acc.VBE.Events.ReferencesEvents<BR>
>> <bound method Events.ReferencesEvents of<win32com.gen_py.Microsoft Visual Basic for Applications Extensibility 5.3.Events instance at 0x17466752>><BR>
>>>>> acc.VBE.Events.ReferencesEvents(None)<BR>
>> <PyIUnknown at 0x0102CFF8 with obj at 0x00190AEC><BR>
>><BR>
>><BR>
>> Original message:<BR>
>>> I am writing a COM addin, and attempting to trap the ItemAdded/ItemRemoved event in the following object:<BR>
>>> Application.VBE.Events.ReferencesEvents<BR>
>>> which is retrieved by passing Nothing as a paramter:<BR>
>>> Application.VBE.Events.ReferencesEvents(Nothing)<BR>
>>><BR>
>>> Tim Golden wrote in the following post (<A HREF="http://mail.python.org/pipermail/python-win32/2009-February/008826.html">http://mail.python.org/pipermail/python-win32/2009-February/008826.html</A>) that pythoncom.Empty can be used for Nothing. However, when trying this:<BR>
>>><BR>
>>> try:<BR>
>>> self.comRefevents=self.app.VBE.Events.ReferencesEvents(pythoncom.Empty)<BR>
>>> except pythoncom.com_error, (hr, msg, exc, arg):<BR>
>>> print "The call failed with code %d: %s" % (hr, msg)<BR>
>>> if exc is None:<BR>
>>> print "There is no extended error information"<BR>
>>> else:<BR>
>>> wcode, source, text, helpFile, helpId, scode = exc<BR>
>>> print "The source of the error is", source<BR>
>>> print "The error message is", text<BR>
>>> print "More info can be found in %s (id=%d)" % (helpFile, helpId)<BR>
>>><BR>
>>> I get back the following (the same as if I had passed no arguments at all):<BR>
>>><BR>
>>> The call failed with code -2147352561: Parameter not optional.<BR>
>>> There is no extended error information<BR>
>>><BR>
>>> Eric Lippert states in his blog (http://blogs.msdn.com/ericlippert/archive/2004/07/14/183241.aspx):<BR>
>>>> A common alternative to passing a missing argument is to pass Nothing, Null, or Empty in VBScript,<BR>
>>>> null or undefined in JScript. Null and null pass VT_NULL, Empty and undefined pass VT_EMPTY, and<BR>
>>>> Nothing passes a VT_DISPATCH with no value dispatch object pointer.<BR>
>>> It would seem that VB's Nothing and Empty are two different things.<BR>
>>><BR>
>>> If I try passing pythoncom.VT_DISPATCH, then I get the following traceback:<BR>
>>><BR>
>>> -----------------------------------------------------------------------------------------------------------<BR>
>>> Traceback (most recent call last):<BR>
>>> File "C:\Python26\lib\site-packages\win32com\universal.py", line 177, in dispatch<BR>
>>> retVal = ob._InvokeEx_(meth.dispid, 0, meth.invkind, args, None, None)<BR>
>>> File "C:\Python26\lib\site-packages\win32com\server\policy.py", line 324, in _InvokeEx_<BR>
>>> return self._invokeex_(dispid, lcid, wFlags, args, kwargs, serviceProvider)<BR>
>>> File "C:\Python26\lib\site-packages\win32com\server\policy.py", line 649, in _invokeex_<BR>
>>> return DesignatedWrapPolicy._invokeex_( self, dispid, lcid, wFlags, args, kwArgs, serviceProvider)<BR>
>>> File "C:\Python26\lib\site-packages\win32com\server\policy.py", line 585, in _invokeex_<BR>
>>> return func(*args)<BR>
>>> File "C:\Documents and Settings\ABG7\My Documents\Zevi\Python-COMAddin\VBACodeRepository.py", line 104, in OnConnection<BR>
>>> self.comRefevents=self.app.VBE.Events.ReferencesEvents(pythoncom.VT_DISPATCH)<BR>
>>> File "C:\Python26\lib\site-packages\win32com\gen_py\0002E157-0000-0000-C000-000000000046x0x5x3.py", line 145, in ReferencesEvents<BR>
>>> ret = self._oleobj_.InvokeTypes(202, LCID, 2, (13, 0), ((13, 1),),VBProject<BR>
>>> TypeError: The Python instance can not be converted to a COM object<BR>
>>> pythoncom error: Unexpected gateway error<BR>
>>><BR>
>>> Traceback (most recent call last):<BR>
>>> File "C:\Python26\lib\site-packages\win32com\universal.py", line 177, in dispatch<BR>
>>> retVal = ob._InvokeEx_(meth.dispid, 0, meth.invkind, args, None, None)<BR>
>>> File "C:\Python26\lib\site-packages\win32com\server\policy.py", line 324, in _InvokeEx_<BR>
>>> return self._invokeex_(dispid, lcid, wFlags, args, kwargs, serviceProvider)<BR>
>>> File "C:\Python26\lib\site-packages\win32com\server\policy.py", line 649, in _invokeex_<BR>
>>> return DesignatedWrapPolicy._invokeex_( self, dispid, lcid, wFlags, args, kwArgs, serviceProvider)<BR>
>>> File "C:\Python26\lib\site-packages\win32com\server\policy.py", line 585, in _invokeex_<BR>
>>> return func(*args)<BR>
>>> File "C:\Documents and Settings\ABG7\My Documents\Python-COMAddin\VBACodeRepository.py", line 104, in OnConnection<BR>
>>> self.comRefevents=self.app.VBE.Events.ReferencesEvents(pythoncom.VT_DISPATCH)<BR>
>>> File "C:\Python26\lib\site-packages\win32com\gen_py\0002E157-0000-0000-C000-000000000046x0x5x3.py", line 145, in ReferencesEvents<BR>
>>> ret = self._oleobj_.InvokeTypes(202, LCID, 2, (13, 0), ((13, 1),),VBProject<BR>
>>> TypeError: The Python instance can not be converted to a COM object<BR>
>>><BR>
>>><BR>
>>> _______________________________________________<BR>
>>> python-win32 mailing list<BR>
>>> python-win32@python.org<BR>
>>> <A HREF="http://mail.python.org/mailman/listinfo/python-win32">http://mail.python.org/mailman/listinfo/python-win32</A><BR>
><BR>
><BR>
<BR>
<BR>
</FONT>
</P>
</BODY>
</HTML>