Question: I built a excel macro using the "Microsoft Outlook 15.0 Object Library" reference, but when I send the file to other people they get this error: "***Can’t find project or library***".

This file will be used by a lot of people, so I have to add it from VBA Code.

I'm using this code that runs when you open the excel file, which is returning the following error: "***Error in loading DLL***"

```
Private Sub Workbook_Open()
       Application.VBE.ActiveVBProject.References.AddFromFile "C:\Program Files (x86)\Microsoft Office\Office15\MSOUTL.OLB\"
End Sub

```

Do you have any idea why this is happening?

Thanks

Answer: 
If you still want to keep the early binding you could use the GUID in order to add the libray, i.e. 

```
Sub AddOL_Ref()

Application.VBE.ActiveVBProject.REFERENCES. _
    AddFromGuid "{00062FFF-0000-0000-C000-000000000046}", 1, 0

End Sub

```

Advantage of using the GUID is that it is constant and does not change with the version of the program.

[Here](https://www.excelcise.org/add-or-remove-object-library-reference-via-vba/) one finds an extened discussion on dis/advantages of early resp. late binding.
You will have to remove the references & use late binding

or you can also try this. Send your code to one of the user having 2010MS.

**Goto VBA > Tools > References** 

Check for any missing references. You may have ***Microsoft Outlook 15.0 Object Library*** showing as missing. Un-check this, browse down and select ***Microsoft Outlook 14.0 Object Library***.