“找不到项目或库”用于标准VBA功能 [英] "Can't find Project or Library" for standard VBA functions
问题描述
所以我必须在我的电脑上运行别人的excel应用程序，而且我在标准功能（如日期，格式，十六进制，中等等）上得到找不到项目或库。
一些研究表明，如果我将这些功能用VBA命名。如VBA.Date那样，它可以正常工作。
网页建议它与我的系统上的项目引用有关，而他们必须在开发者系统。我将要从别人处理这段时间，并将这些应用程序分发给许多其他应用程序，所以我需要了解我需要修复的excel设置有什么问题，或者需要在xls文件，以便它可以在各种系统上运行。我想避免让大家使用VBA。作为一个明确的参考，但如果没有理想的解决方案，我想这就是我们要做的。
- 我如何使VBA 。隐藏在我的项目属性/引用/ etc中？
-Adam
如果引用了完全不同的库，我已经看到了标准函数的错误。
在VBA编辑器中，从菜单启动编译命令，然后检查引用对话框，看看是否有任何错误，如果有的话，尝试添加这些库。 p>
一般来说，编译完整的VBA代码，然后在分发之前保存文档似乎是很好的做法。
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.
Some research indicates that if I prefix these functions with "VBA." as in "VBA.Date" then it'll work fine.
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.
- How do I make "VBA." implicit in my project properties/references/etc?
-Adam
I have seen errors on standard functions if there was a reference to a totally different library missing.
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.
In general it seems to be good practice to compile the complete VBA code and then saving the document before distribution.
这篇关于“找不到项目或库”用于标准VBA功能的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
