Late Bookbinding Events

Question

I can subscribe to Outlook events using the following in the Class Module , where myOlApp uses early binding

 '**Class Module - clsOutlookHandler ** Public WithEvents myOlApp As Outlook.Application Private Sub Class_Initialize() On Error Resume Next Set myOlApp = GetObject(, "Outlook.Application") If Err.Number = 429 Then Set myOlApp = CreateObject("Outlook.Application") Err.Clear End If On Error GoTo 0 End Sub 

To do this, I need to make sure that the links are checked for the Microsoft Outlook X object library.

Is this possible or is there any “trick” for subscribing to Outlook events (or any application) using late binding?

For example, I know the following inapplicable work - is there a workaround in VBA?

 Public WithEvents myOlApp As Object 

Answer 1

If you include a link to a specific version of Microsoft Outlook (or any other software, for that matter), and the end user has a later version of this software, the link will continue to work, provided that the provider of this software correctly configured version inheritance and did not interrupt the changes.

However, if the end user has an earlier version of the software (such as Outlook), the link will not work, so you need to configure the link to the earliest version of this software that you are going to support.

This way you can avoid late binding in general and still allow multiple versions of the linking software.

You just need to be careful not to update links to older versions of your referenced software, to newer versions, or you could split your book for users with older versions of software.