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

[Tim Golden]

[Tom_RobbinsMilne at swissre.com]

| 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. 

I'm not sure about the CreateObject bit, not being a
VBA person, but I suspect you may want to use the
DispatchEx method rather than simply Dispatch. eg,

[some spreadsheet already open]

<code>
import win32com.client

xl = win32com.client.DispatchEx ("Excel.Application")
wb = xl.Workbooks.Add ()
ws = xl.ActiveSheet

ws.Cells (1, 1).Value = "Hello"

wb.SaveAs ("c:/temp/temp.xls")
wb.Close ()
xl.Quit ()

xl = None
</code>

[original spreadsheet still open]

TJG

________________________________________________________________________
This e-mail has been scanned for all viruses by Star. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
________________________________________________________________________