Dispatch("Excel.Application") = Access denies

andrew.j.atkinson at unilever.com andrew.j.atkinson at unilever.com
Tue Dec 19 05:11:57 EST 2000


Dear all

Have developed a python app to automate the running of an excel 
spreadsheet. Works a treat when run on the command line, however get 
the following 'trace' when run through Tivoli's Maestro job scheduler 
(same user in both cases).

Any ideas (it's quite urgent).

Traceback (most recent call last):
  File "e:\rlnklive\bin\test.py", line 24, in ?
    xlApp=Dispatch("Excel.Application")
  File "e:\python20\win32com\client\__init__.py", line 94, in Dispatch
    dispatch, userName = dynamic._GetGoodDispatchAndUserName
(dispatch,userName,clsctx)
  File "e:\python20\win32com\client\dynamic.py", line 80, in 
_GetGoodDispatchAndUserName
    return (_GetGoodDispatch(IDispatch, clsctx), userName)
  File "e:\python20\win32com\client\dynamic.py", line 71, in 
_GetGoodDispatch
    IDispatch = pythoncom.CoCreateInstance(IDispatch, None, clsctx, 
pythoncom.IID_IDispatch)
pywintypes.com_error: (-2147024891, 'Access is denied.', None, None)

Kind Regards
-Andrew






More information about the Python-list mailing list