You can select another application's objects that you want available in your code by setting a reference to that application's object library.
Add an object
From the Developer tab, open a Visual Basic project window. See Make the Developer tab visible below if it's not open.
-
On the Tools menu, click References.
-
Under Available References, select the check box for the object library that you want available in your Visual Basic project.
Note: You should clear the check box for the object libraries that you do not want in your Visual Basic project to reduce the time it takes to compile.
-
To set the order in which the object libraries are accessed, under Available References, select the object library, and then click the Priority buttons to move the object library up or down.
-
To add other object libraries to Available References, click Browse, and then find the object library that you want.
-
-
On the top bar, select Excel > Preferences > Ribbon & Toolbar.
-
Under Customize the Ribbon, select Main Tabs and then check Developer.
-
Click Save and then close Excel Preferences.