[python-win32] win32 error running on python 3 and win 64 machine

[Nabeela]

Hi,

i'm trying to run the following code and get this error


import win32com.client as win32import os

excel = win32.gencache.EnsureDispatch('Excel.Application')


Traceback (most recent call last):
  File
"C:\Users\nabeelah.bijapur\Documents\Anaconda3\lib\site-packages\win32com\client\gencache.py",
line 532, in EnsureDispatch
    ti = disp._oleobj_.GetTypeInfo()
pywintypes.com_error: (-2147418111, 'Call was rejected by callee.', None,
None)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File
"C:\Users\nabeelah.bijapur\Documents\Anaconda3\lib\site-packages\win32com\client\gencache.py",
line 543, in EnsureDispatch
    raise TypeError("This COM object can not automate the makepy process -
please run makepy manually for this object")
TypeError: This COM object can not automate the makepy process - please run
makepy manually for this object

What is the solution for this.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-win32/attachments/20160630/301e12f8/attachment.html>