"ago" <[EMAIL PROTECTED]> wrote in message 
news:[EMAIL PROTECTED]
> solved, if it can be useful to others here is my code:
>
> import pythoncom
> import win32com.client
>
> def getWorkbook(workbookName):
> lenstr = len(workbookName)
> workbook = None
> rot = pythoncom.GetRunningObjectTable()
> rotenum = rot.EnumRunning()
> while True:
> monikers = rotenum.Next()
> if not monikers: break
> ctx = pythoncom.CreateBindCtx(0)
> name = monikers[0].GetDisplayName(ctx, None);
> if name[-lenstr:] == workbookName:
> obj = rot.GetObject(monikers[0])
> workbook =
> win32com.client.Dispatch(obj.QueryInterface(pythoncom.IID_IDispatch))
> return workbook

Perhaps you can submit this to the Python Cookbook at oreilly.com (sp?)




-- 
http://mail.python.org/mailman/listinfo/python-list

Reply via email to