LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.misc
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Late binding to Excel from Access causing Object error EagleOne@microsoftdiscussiongroups[_2_] Excel Discussion (Misc queries) 4 June 14th 08 12:45 AM
cannot start the source application for this object in excel Philip Mollica Charts and Charting in Excel 3 May 27th 06 02:46 AM
Opening excel spreadsheets via excel.application object w/o prompts Andy S. Excel Worksheet Functions 2 August 24th 05 04:57 PM
VB Extensibility library and "late binding" Dennis Excel Discussion (Misc queries) 0 March 30th 05 10:51 PM
"Excel.Application" Object Model Shaker Charts and Charting in Excel 2 January 9th 05 10:24 AM


All times are GMT +1. The time now is 07:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"