如何引用旧版本的VBA库? [英] How to reference an old version of the VBA library?
问题描述
我正在使用Excel2013.VBA参考是Excel的一部分(内置)，所以我无法将其删除.
I'm using Excel 2013. The VBA reference is part of Excel (built-in) so I can't remove it.
是否可以引用另一个版本的VBA库?除了好奇心外，我想知道的其他原因是查看较旧版本的对象浏览器，以查看其是否列出了一些当前隐藏/过时的属性/方法，例如Excel.DialogSheet .
Is it possible to reference another version of the VBA library? The reason I want to know other than curiosity is to look at the object browser of the older versions to see if it lists some currently-hidden/obsolete properties/methods such as Excel.DialogSheet.
Workbook.SheetActivate事件具有对象类型的Sh参数.可能的工作表类型之一是 Excel.DialogSheet ，应该使用TypeOf运算符检查 .
The Workbook.SheetActivate event has a Sh parameter of type Object. One of the possible sheet types is Excel.DialogSheet which should be checked with the TypeOf operator.
当我尝试添加另一个VBA引用时，收到消息:Name conflicts with existing module, project, or object library.
When I try to add another VBA reference I get the message: Name conflicts with existing module, project, or object library.
默认使用的是来自:
- C:\ Program Files \ Common Files \ Microsoft共享\ VBA \ VBA7.1 \ VBE7.DLL
其他可用的参考资料来自:
The other references available are from:
- C:\ Windows \ System32 \ msvbvm60.dll
- C:\ WINDOWS \ system32 \ VEN2232.OLB
我还检查了另一台使用Excel 2003的计算机，该计算机使用:
I also checked another computer with Excel 2003 that uses:
- C:\ Program Files \ Common Files \ Microsoft共享\ VBA \ VBA6 \ VBE6.DLL
并具有:
- C:\ WINDOWS \ system32 \ VEN2232.OLB
- C:\ WINDOWS \ system32 \ MSVBM50.DLL
- C:\ WINDOWS \ system32 \ MSVBM60.DLL
- C:\ WINDOWS \ system32 \ VBAEND32.OLB
推荐答案
简单的答案是否定的.另外，也没有必要.只需打开对象浏览器，右键单击某些内容，然后选择显示隐藏的成员".然后，您可以浏览所有已弃用的功能，例如DialogSheet. :)
Simple answer is no. Also, there is no need to. Just open the Object Browser, right-click something and choose 'Show hidden members'. You can then browse all the deprecated features like DialogSheet to your heart's content. :)
这篇关于如何引用旧版本的VBA库?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
