View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
[email protected] patstix@gmail.com is offline
external usenet poster
 
Posts: 8
Default Excel References Not Release When IDTExtensibility2 Used

Joel - you said "You need to use CloseEvent and pass it the Handle
Number. "
You then again reference the "closeevent function" in your follow up
post, but link to a function that closes the handle, called
CloseHandle. Was that just a mistake on the name of the function, or
did you mean to link something else?
thanks!


On Sep 17, 2:41*pm, Joel wrote:
A handle is a linked lists of event that is usually in windows triggered by
the Tick timer. *When a timer event occurs windows goes down the list of
events and runs each process. *When you stop a handle you need to remove the
handle from the link list of events and kill the process. *The closeEvent I
belive does both operations, unlink the event and stops the process.

Description of what a handle ishttp://msdn.microsoft.com/en-us/library/ms724176(VS.85).aspx

closeevent functionhttp://msdn.microsoft.com/en-us/library/ms724211.aspx

" wrote:
Joel - can you clarify that please? *How do I "use" CloseEvent? *If
you mean the workbook close event, then what should I do there with
the handle number? *As you can see, I'm already removing the
registration of the handler.
thanks!


On Sep 17, 1:23 pm, Joel wrote:
You need to use CloseEvent and pass it the Handle Number.