Access 2007:Excel对象库 [英] Access 2007: excel object library

问题描述

嗨 我正在Access 2007中开发VBA应用程序.要运行该项目，我必须通过在添加引用"对话框中选择"Excel 12.0对象库"来包括它.问题是，如果我转到添加引用菜单，则找不到任何库.该对话框为空.在哪里可以找到图书馆?我试图重新安装Office套件，但是它不起作用.

Hi i''m developing a VBA application in Access 2007. To run the project, I have to include the "excel 12.0 object library" by selecting it in the "add reference" dialog. The problem is that if i go to the add reference menu, i can''t find any library. The dialog is empty. where can i find the library? I''ve tried to reinstall the office suite, but it doesn''t work .

推荐答案

"COM"选项卡是否真的为空?对我来说似乎不太可能.

打开添加引用"对话框，切换到"COM"选项卡
，然后向下滚动到"Microsoft Excel 10.0对象库".

Is the "COM" tab really empty? Seems unlikely to me.

Open the "Add Reference" dialog, switch to the "COM" tab
and scroll down to "Microsoft Excel 10.0 Object Library".

没有对话框中的选项卡...

There are no tabs in the dialog...

感谢所有人！
通过使用VBA窗口中的菜单而不是Access之一来解决.

Thanks to all!
Solved by using the menu in the VBA window instead of the Access one.

这篇关于Access 2007:Excel对象库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！