View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
[email protected][_2_] Mr.Frog.to.you@googlemail.com[_2_] is offline
external usenet poster
 
Posts: 8
Default Late Binding issue with Excel.Application object

Hi Jim,

Thankyou for the feedback. I am aware of the events system in Excel.
My issue is that when that system is disabled, and a new workbook is
opened, the events system state changes to enabled again. This is not
the behavior that is supposed to happen. The events system is part of
the application, not the workbook - the workbook has events, but they
only activate (or are fired) when events system is enabled. This is
not the behaviour that Excel is displaying when changing from early
binding to late binding.

In short, using early binding the code works, using late binding the
behaviour of the application object is different with
the .EventsEnabled property changing state without being told to do
so.

Has anyone got any ideas how to solve this?

The Frog