"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