Excel Question

Robin Becker robin at jessikat.demon.co.uk
Sun Feb 6 14:37:10 EST 2000


In article <PWhn4.13540$Uz3.155747 at typhoon.midsouth.rr.com>, Bill
Wilkinson <bwilk_97 at yahoo.com> writes
>Hello
>
>I use Excel in a Python application I have written.  It works wonderfully
>most of the time.  But from time to time my user will have two copies of
>Excel open.  So when I run the code:
>
>>>> import win32com.client
>>>> e = win32com.client.Dispatch("Excel.Application")
>
>I never know which running version of Excel I am going to connect to.  Does
>anyone know of a way to assure that I am connecting to the running version
>that the user is currently working with?
>
>fyi.. my program is called by a button on the open Excel spread sheet.
>
>Many thanks for any suggestions.
>
>
Why don't you make the python a server instead of a client. Then your
excel could call a small vba routine to open up a python com object.
-- 
Robin Becker



More information about the Python-list mailing list