win32 com problem

[Mike P]

I've got a slight problem when running an excel macro from python using
the win32.com.client module, in that it says it can't load the DLL file
(it doesn't say which one)

and gives me the following error message

Traceback (most recent call last):
  File "<string>", line 93, in ?
  File "<COMObject <unknown>>", line 14, in Run
  File "C:\Python24\lib\site-packages\win32com\client\dynamic.py", line
258, in _ApplyTypes_
    result = self._oleobj_.InvokeTypes(*(dispid, LCID, wFlags, retType,
argTypes) + args)
pywintypes.com_error: (-2147352567, 'Exception occurred.', (0,
'Microsoft Office Excel', "The macro 'CTP.xla!sheet1.CTP' cannot be
found.", 'C:\\Program Files\\Microsoft
Office\\OFFICE11\\1033\\xlmain11.chm', 0, -2146827284), None)


Anybody have any ideas what this means?