Add event handler to an object? 3

[1DMF]

How do I add an event handler to an object in MS Access VBA?

I have

    Dim objFolder As Object
    Set objFolder = oApp.GetNamespace("MAPI").GetDefaultFolder(olFolderSentItems)
    AddHandler objFolder.ItemAdd

It won't compile because it appears AddHandler isn't VBA.

However, I seem unable to dimension the objFolder object 'WithEvents' ?

How do I add the event handler for the 'ItemAdd' event on the 'Sent Items' MAPI folder object objFolder?

Thanks,
1DMF

"In complete darkness we are all the same, it is only our knowledge and wisdom that separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"

Free Dance Music Downloads

 

[PHV]

I remember my suggestion of late binding to avoid version issues.
But now you want to trap automation events ...

 

[1DMF]

Hey, don't take that comment the wrong way! I'm very grateful for your support in 'un-binding' my apps, which is why I don't want to go back!

Have another star - though it seems you don't need any more, as once again you are Tek-Tips MVP!

"In complete darkness we are all the same, it is only our knowledge and wisdom that separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"

Free Dance Music Downloads

 

[MajP]

You could always create an ActiveX library that only contains a single object - a proxie that only implements the eventhandler. It can early bind, and you can early bid to it without impacting the late binding to Outlook

Any chance you are willing to provide some code, more details, or a reference to what you are suggesting? I am somewhat skeptical.

 

[strongm]

Unfortunately I'm currently nowhere near a machine with the necessary resources to test this out, and won't be until the New Year. However, I can see absolutely nothing wrong with the principle.