“找不到项目或库"用于标准 VBA 函数 [英] "Can't find Project or Library" for standard VBA functions

问题描述

因此，我不得不在我的 PC 上运行其他人的 excel 应用程序，并且在日期、格式、十六进制、中位数等标准功能上出现找不到项目或库".

So I'm having to run someone else's excel app on my PC, and I'm getting "Can't find Project or Library" on standard functions such as date, format, hex, mid, etc.

一些研究表明，如果我在这些函数前面加上VBA".就像在VBA.Date"中一样，它会正常工作.

Some research indicates that if I prefix these functions with "VBA." as in "VBA.Date" then it'll work fine.

网页表明它与我系统上的项目引用有关，而它们在开发人员的系统上必须没问题.我将在一段时间内从其他人那里处理这个问题，并将这些应用程序分发给许多其他人，所以我需要了解我需要修复的 excel 设置有什么问题，或者需要在xls 文件，以便它可以在各种系统上运行.我想避免让每个人都使用VBA".作为明确的参考，但如果没有理想的解决方案，我想这就是我们必须要做的.

Webpages suggest it has to do with my project references on my system, whereas they must be ok on the developer's system. I'm going to be dealing with this for some time from others, and will be distributing these applications to many others, so I need to understand what's wrong with my excel setup that I need to fix, or what needs to be changed in the xls file so that it'll run on a variety of systems. I'd like to avoid making everyone use "VBA." as an explicit reference, but if there's no ideal solution I suppose that's what we'll have to do.

• 如何制作VBA".隐含在我的项目属性/引用/等中?

-亚当

推荐答案

如果缺少对完全不同的库的引用，我发现标准函数会出错.

I have seen errors on standard functions if there was a reference to a totally different library missing.

在 VBA 编辑器中，从菜单中启动编译命令，然后检查引用对话框以查看是否缺少任何内容，如果有，请尝试添加这些库.

In the VBA editor launch the Compile command from the menu and then check the References dialog to see if there is anything missing and if so try to add these libraries.

一般来说，编译完整的 VBA 代码，然后在分发前保存文档似乎是一个好习惯.

In general it seems to be good practice to compile the complete VBA code and then saving the document before distribution.

这篇关于“找不到项目或库"用于标准 VBA 函数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！