Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Accessing events of com objects

Hi All

first appologies if I get all the terminology wrong, It is ages since
I have done any of this and I am rusty....

I am working with an API which exposes its objects to me but is not
available as an object within excel (late bound??) so I access it
using

Dim MyObj as Object
Set MyObj = GetObject("FOO")

Rather than being able to do:

Dim MyObj as FOO

because the objects are not registered (and I cannot count on them
being on the target machines)

I can access the properties of MyObj at runtime:
Dim MyObj as Object
Dim Counter as integer
Set MyObj = GetObject("FOO")
Counter = MyObj.Count

but I know it has 2 events and I want to be able to catch those (in
WScript I think I can use "ConnectObject") - is there a way of setting
the event handlers to be part of my VBA (either in a class module or
normal module)

T

Reply
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
How to reach Application Objects in Events? NOPIK Excel Programming 3 February 25th 07 05:27 PM
MS Dialog 5.0 sheets - Accessing data elements of objects Malriem Excel Worksheet Functions 2 June 4th 05 04:46 PM
Unable to remove Sheet objects in the Microsoft Excel Objects Adrian[_7_] Excel Programming 1 August 26th 04 10:49 PM
Mouse over events for Active X objects in excel Shrinu Excel Programming 1 May 26th 04 10:42 PM
structure of classes,objects,properties,methodes,events... Jan Eikeland Excel Programming 2 December 24th 03 10:49 AM


All times are GMT +1. The time now is 08:10 PM.

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

About Us

"It's about Microsoft Excel"