Hi.
I'm trying to implement an Excel add-in based on the demo I found in
win32com/demos (excelAddin.py)
The demo basically adds a CommandBar with a Button and register itself. What
I'm trying to do is change the OnClick event to perform some operation in
the ActiveSheet of the Excel instance in which the Button is clicked on. The
relevant code snippet is then:
def OnClick (self, button, cancel):
xl = win32com.client.Dispatch('Excel.Application')
<cut on the rest of the performed operations>
It works fine if I have only one Excel instance running. If there are more
instances, Dispatch invokes the first one, which is not necessarily the
desired one.
To work around, first I have tried to get a reference to the Application
from the OnClick event, but I didn't be able to find any.
After some googling, I've tried a less obvious way, querying the Running
Object Table to get some reference about running instances. I manage to get
the monikers of running objects, but I don't know how - and if possible -
pass them to a function to get the object by reference. So, I wonder if
there is a more newbie-ish method to reach my goal.
Any help, hint or pointers would be greatly appreciated.
Regards,
Marco
_______________________________________________
Python-win32 mailing list
Python-win32@python.org
http://mail.python.org/mailman/listinfo/python-win32
