[python-win32] Forcing win32com.client.dispatch to start up a fresh Excel

Tom_RobbinsMilne@swissre.com Tom_RobbinsMilne at swissre.com
Mon Jun 20 23:47:29 CEST 2005


Hi,

I'm trying to use Python's win32com interface to drive an excel 
spreadsheet.

I've managed to have it open the sheet, call a VBA function with 
arguments, and close it down cleanly.

However, if Excel is already running, it closes the open instance. Which 
is not good.

Is there a way I can do the equivalent of VBA's CreateObject() with 
win32com? I have purchased "Python Programming on Win32", and can't find 
anything.

Soon I'll be reduced to running a short Perl script to do it, where I'd 
have Python kick off the Perl to get the job done, but I'd like to avoid 
that if possible.

Thanks very much in advance.

Regards,
Tom



This e-mail, including attachments, is intended for the person(s) or company named and may contain confidential and/or legally privileged information. Unauthorized disclosure, copying or use of this information may be unlawful and is prohibited. If you are not the intended recipient, please delete this message and notify the sender
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.python.org/pipermail/python-win32/attachments/20050620/7a122a62/attachment.htm


More information about the Python-win32 mailing list