0

I have a code that generates a meeting on outlook automatically according to the data you have given in a userform. I have tested this and it works fine but the first time I ran it it gave me an error which I corrected by enabling the Microsoft Outlook 16.0 Object Library. I was wondering if there is any way to enable this library automatically through code so that everybody who uses this macro will not have to enable it manually when they use it.

Edit: now that I am thinking about it, when I enable this library on my computer, is it enabling it only for my computer or is it enabling it on the workbook? Meaning that if I enable it, then will it be enabled for others who open this workbook too?

braX
  • 11,506
  • 5
  • 20
  • 33
sam0406
  • 25
  • 5
  • For more reading, see the [docs](https://learn.microsoft.com/en-us/office/vba/language/how-to/check-or-add-an-object-library-reference). Also useful: [this](http://www.cpearson.com/excel/missingreferences.aspx). – BigBen Jun 12 '20 at 14:35
  • Have a look at *early* vs *late* binding here: https://stackoverflow.com/questions/49789611/vba-early-vs-late-binding-real-life-performance-differences – Kostas K. Jun 12 '20 at 14:37

0 Answers0