Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to reach Application Objects in Events? | Excel Programming | |||
MS Dialog 5.0 sheets - Accessing data elements of objects | Excel Worksheet Functions | |||
Unable to remove Sheet objects in the Microsoft Excel Objects | Excel Programming | |||
Mouse over events for Active X objects in excel | Excel Programming | |||
structure of classes,objects,properties,methodes,events... | Excel Programming |