View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Rob Bruce Rob Bruce is offline
external usenet poster
 
Posts: 10
Default Capture Excel Events from other application

George Eskildsen wrote:
Thanks a lot for your reply. It is really help. But I wonder if it
work using late binding for example Getobject(,Excel.Application).


Well, the withevents declaration doesn't work with late binding. However,
GetObject is NOT late binding. If you assign the return value of GetObject
to an early-bound variable, then withevents will work.

Rob