×
英语
很抱歉。本文没有你的语言版本。

Add object libraries to your Visual Basic project

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.

  1. On the Tools menu, click References.

    Preferences selection on Tools menu

  2. Under Available References, select the check box for the object library that you want available in your Visual Basic project.

    Available references dialog

    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.

  3. 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.

  4. To add other object libraries to Available References, click Browse, and then find the object library that you want.

  5. Browse for an object

  1. On the top bar, select Excel > Preferences > Ribbon & Toolbar.

  2. Under Customize the Ribbon, select Main Tabs and then check Developer.

  3. Click Save and then close Excel Preferences.

扩展你的 Office 技能
了解培训
抢先获得新功能
加入 Office 预览体验计划

此信息是否有帮助?

谢谢您的反馈!

谢谢你的反馈! 可能需要转接到 Office 支持专员。

×