Here are some steps to follow, to allow you to add a reference to the Microsoft Office Object Library from within Excel. Steps 1, 2 & 3 can be skipped via ALT+F11, but it’s handy to have the developer tab added for later on.
Depending on your version of Office, these steps or the names of the objects may differ slightly – Office 2010 is 14.0, Office 2012 is 15.0 etc
1: Firstly, add the Developer tab to Excel – Right-click anywhere in the ribbon & select ‘Customise The Ribbon’:
2: Put a check in the ‘Developer’ box & hit ‘OK’:
3: Switch to the Developer tab, and hit the Visual Basic shortcut:
4: Select Tools > References:
5: Scroll down to the required Library, add a check box, and hit ‘OK’