[Tutor] Win32com/Excel
Terje Johan Abrahamsen
terjeja@hotmail.com
Tue, 11 Jun 2002 22:31:01 +0000
I try to open Excel thru win32com. I write:
>>>from win32com.client import Dispatch
>>>xlApp = Dispatch("Excel.Application")
>>>xlApp.Visible = 1
I get the frame of Excel, but not the spreadsheet. Even if I write:
>>>xlApp.Workbooks.Add()
it doesn't give me the ability to look whats there. I get the frame around
the spreadsheet, and the menues at the top, as well as the paperclip. The
paperclip works, the menus are selectable, but does not work. And the space
where the spreadsheet should have been gives me a "picture" of what is on
the desktop. (Other open windows in the background and so forth). I can move
the Excel frame around, and the background follows along. I use the newest
version of both Python and Win32com, and have tried this on two computers. 1
with Win98 and 1 with win2k. Same result... Anyone seen this before? And
managed to solve it?
Thanks,
Terje
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.