Sinking events for late bound objects ?

[Jaafar Tribak]

Hi there.

I don't think this is even possible but it won't hurt to ask .

Can we sink events of a late bound object ie :an Object accessed/automated via the CreateObject function and therefore without being able to use the WithEvents keyword ?

For example : Use Createobject to create a new instance of a Word document and somehow capture the Word document events from excel.

 

[Greg Truby]

Totally late-bound in the sense that the project contains no references to the Word object library in this case?

 

[Jaafar Tribak]

Totally late-bound in the sense that the project contains no references to the Word object library in this case?

Yes Greg. No reference to the library of the automated object thus the impossibility to use the WithEvents keyword. - Thank you.

 

[Sektor]

Hope this will help.

 

[Jaafar Tribak]

Hope this will help.

Thanks Sektor - will take a close look.

I've actually already done some googling before asking here but only found code in languages other than VB and/or code that needs third party components.

 

[Sektor]

I have found this link in 10 seconds. This depends on what you're typing in text box.

 

[Jaafar Tribak]

Ok- In case anyone is interested and want to venture into some low level COM, here is some amazing code I found in <cite>planet-source-code</cite> which implements the low level COM interfaces IConnectionPoint or IDispatch using plain VBA - No addintional components needed.

The code I found was for sinking events for IExplorer but I adapted it to sink events for excel .

here is a workbook demo.

 

[Greg Truby]

At this point I haven't any need to do this. But rest assured I have downloaded the workbook just in case I ever need to try something along these lines.