On Jul 10, 8:40 pm, Lance Hoffmeyer <[EMAIL PROTECTED]> wrote: > Hey all, > > I am trying to create some python code to edit embedded ppt slides and need > some help. > > import win32com.client > from win32com.client import constants > import re > import codecs,win32com.client > import time > import datetime > import win32com.client.dynamic > ###################################################### > ############ VARIOUS VARIABLES TO SET ################ > path = "C:\temp/" > ###################################################### > ###################################################### > > PPT=win32com.client.Dispatch("PowerPoint.Application") > WB=PPT.Presentations.Open(path + "File.ppt") > PPT.Visible=1 > PPTSLIDE= 29 > > for Z in WB.Slides(29).Shapes: > if (Z.Type== 7): > ZZ=Z.OLEFormat.Object > WSHEET = ZZ.Worksheets(1) > WSHEET.Range("A1").Value = .50 > WSHEET.Range("A1").NumberFormat="0%" > > Gives error: > > Traceback (most recent call last): > File "P:\Burke\TRACKERS\Ortho-McNeil\04 2007, 04-10 WAVE > 4\Automation\Document1.py", line 23, in ? > WSHEET = ZZ.Worksheets(1) > File "C:\Program > Files\Python\lib\site-packages\win32com\client\dynamic.py", line 489, in > __getattr__ > raise AttributeError, "%s.%s" % (self._username_, attr) > AttributeError: <unknown>.Worksheets > > Tool completed with exit code 1 > > Why is ZZ unknown and how to I correct this? > > Thanks in advance, > > Lance
""" How do I know which methods and properties are available? Good question. This is hard! You need to use the documentation with the products, or possibly a COM browser. Note however that COM browsers typically rely on these objects registering themselves in certain ways, and many objects to not do this. You are just expected to know. The Python COM browser PythonCOM comes with a basic COM browser that may show you the information you need. Note that this package requires Pythonwin (ie, the MFC GUI environment) to be installed for this to work. There are far better COM browsers available - I tend to use the one that comes with MSVC, or this one! To run the browser, simply select it from the Pythonwin Tools menu, or double-click on the file win32com\client\combrowse.py """ -- s|a fynali -- http://mail.python.org/mailman/listinfo/python-list