Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bug in Excel? Excel Multithreading ERROR
Hi, I am writing an multithreaded Excel Add-in program and an error. I
currently have no clue how to solve this. Please help. The description is as below: I created an Excel Add-in in C#. The add-in contains a separate thread that read and write to the worksheet constantly. I got a COMException when the program is accessing to the cell while I clicking on the worksheet. HRESULT of the exception is: 0x800AC472 I could mitigate this problem by having the add-in to retry after this exception occur. However, Excel will not exit cleanly after exception occur. That is, the Excel process still running after my add-in have been shutted down and Excel window closed. I have to kill the process manually :( Anyone having the same problem? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bug in Excel? Excel Multithreading ERROR
"JCChin" wrote in message ... Hi, I am writing an multithreaded Excel Add-in program and an error. I currently have no clue how to solve this. Please help. The description is as below: I created an Excel Add-in in C#. The add-in contains a separate thread that read and write to the worksheet constantly. I got a COMException when the program is accessing to the cell while I clicking on the worksheet. HRESULT of the exception is: 0x800AC472 I could mitigate this problem by having the add-in to retry after this exception occur. However, Excel will not exit cleanly after exception occur. That is, the Excel process still running after my add-in have been shutted down and Excel window closed. I have to kill the process manually :( Anyone having the same problem? I think it's a bad idea to write a multi threaded add-in. My guess is that Excel is not in the state it should be in when this add-in tries access a cell while you try to access some other cell. Why does it constantly have to read and write to the worksheet? /Fredrik |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 - error saving file & error loading dll | Excel Discussion (Misc queries) | |||
Counting instances of found text (Excel error? Or user error?) | Excel Worksheet Functions | |||
Multithreading in Excel | Excel Discussion (Misc queries) | |||
Excel 2003 Macro Error - Runtime error 1004 | Excel Discussion (Misc queries) |