Hi, 1. Put your COM invokations in a try/except loop. From my experience, that helped me prevent, in most cases, Excel from "hanging" and having to restart the PC too. In the except part, release the Excel (or other COM resource) (e.g.calling workbook.Close() or excelobj.Quit(), depending on the state of your program)
2. Look at http://www.faqts.com/knowledge_base/entry/versions/index.phtml?aid=5847 to see how to get the actual error. 3. Delete instances of the COM connection, RS object or whatever win32com.client instances you create. I do this: sheetobj = None wbkbobj = None excelobj = None del sheetobj del wbkobj del excelobj 4. At the end of my scripts, I do the following during the development stage: ActiveComConn = pythoncom._GetInterfaceCount() print 'Done! Active Com Connections :',ActiveComConn # Print count of Active COM connections. Thank you, --Kartic -- http://mail.python.org/mailman/listinfo/python-list
