blocks|key|353982|text|如果缺少对完全不同的库的引用，我就会看到标准函数出现错误。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|353983|在VBA编辑器中，从菜单中启动Compile命令，然后检查References对话框，查看是否缺少任何内容，如果缺少，则尝试添加这些库。|353984|通常，编译完整的VBA代码，然后在分发之前保存文档似乎是一种很好的做法。|353985|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

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.

blocks|key|351242|text|我遇到过这个问题，并发现在用户机器上，我所依赖的一个库在引用对话框中被标记为“缺失”。在这种情况下，在我的Office2007版本中可以使用的是一些office字体库，但在客户端桌面上没有。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|351243|您得到的错误完全是在转移注意力(正如divo所指出的)。|351244|幸运的是，我没有使用库中的任何东西，所以我能够从XLA引用中完全删除它。我猜，divo的扩展建议的最佳实践将是测试以检查所有目标Office版本上的XLA+(无论如何都不是一个坏主意)。|351245|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

I have experienced this exact problem and found, on the users machine, one of the libraries I depended on was marked as "MISSING" in the references dialog. In that case it was some office font library that was available in my version of Office 2007, but not on the client desktop. 

The error you get is a complete red herring (as pointed out by divo).

Fortunately I wasn't using anything from the library, so I was able to remove it from the XLA references entirely. I guess, an extension of divo' suggested best practice would be for testing to check the XLA on all the target Office versions (not a bad idea in any case).

blocks|key|354008|text|在我的例子中，这个函数是不明确的，因为它是在VBA库(在我的参考中存在)和Microsoft+Office对象库(也存在)中定义的。我删除了Microsoft+Office对象库，瞧！不需要使用VBA。前缀。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|354009|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

In my case, it was that the function was AMBIGUOUS as it was defined in the VBA library (present in my references), and also in the Microsoft Office Object Library (also present). I removed the Microsoft Office Object Library, and voila! No need to use the VBA. prefix.

blocks|key|354029|text|我也有同样的问题。这对我很有效：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|354030|在VB中|354031|转到Tools»References|unordered-list-item|354032|Uncheck库"Crystal+Analysis+Common+Controls+1.0“。或任何库。Excel只需保留以下5个引用:+Excel+for+Applications+(这是定义language.)|354033|Microsoft+world.)|354034|Microsoft对象库的库(它定义了|354035|的所有元素)。)|354036|OLE自动化(它指定了链接和嵌入文档的类型，以及其他应用程序的自动化类型，以及用来与外部|354037|通信的COM系统的“管道”(它定义了所有程序的公共内容，如命令栏和命令栏控件.)|ordered-list-item|354038|Microsoft+Forms+2.0如果使用的是用户表单，则此选项是必需的。这个库定义了诸如用户窗体和可以放在窗体上的控件之类的东西。|354039|354040|354041|354042|​|354043|354044|，然后保存。|354045|354046|entityMap^0|0|0|0|0|0|0|0|1|2|2|1|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|16|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|17|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|18|8|@]|9|@]|A|$]]|$1|G|3|H|5|F|7|19|8|@]|9|@]|A|$]]|$1|I|3|J|5|F|7|1A|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|1B|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|1C|8|@]|9|@]|A|$]]|$1|O|3|P|5|F|7|1D|8|@]|9|@]|A|$]]|$1|Q|3|R|5|S|7|1E|8|@]|9|@]|A|$]]|$1|T|3|U|5|S|7|1F|8|@]|9|@]|A|$]]|$1|V|3|-4|5|6|7|1G|8|@]|9|@]|A|$]]|$1|W|3|-4|5|6|7|1H|8|@]|9|@]|A|$]]|$1|X|3|-4|5|6|7|1I|8|@]|9|@]|A|$]]|$1|Y|3|Z|5|6|7|1J|8|@]|9|@]|A|$]]|$1|10|3|-4|5|6|7|1K|8|@]|9|@]|A|$]]|$1|11|3|12|5|F|7|1L|8|@]|9|@]|A|$]]|$1|13|3|-4|5|6|7|1M|8|@]|9|@]|A|$]]|$1|14|3|-4|5|6|7|1N|8|@]|9|@]|A|$]]]|15|$]]

I had the same problem. This worked for me: 

<ul>
<li>In VB go to Tools &raquo; References</li>
<li>Uncheck the library "Crystal Analysis Common Controls 1.0". Or any library.</li>
<li>Just leave these 5 references:
<ol>
<li>Visual Basic For Applications (This is the library that defines the VBA language.)</li>
<li>Microsoft Excel Object Library (This defines all of the elements of Excel.)</li>
<li>OLE Automation (This specifies the types for linking and embedding documents and for automation of other applications and the "plumbing" of the COM system that Excel uses to communicate with the outside world.)</li>
<li>Microsoft Office (This defines things that are common to all Office programs such as Command Bars and Command Bar controls.)</li>
<li>Microsoft Forms 2.0 This is required if you are using a User Form. This library defines things like the user form and the controls that you can place on a form. </li>
</ol></li>
<li>Then Save.</li>
</ul>

blocks|key|351301|text|在我的例子中，我是在家里的办公室电脑(安装了Visio)上(没有安装Visio+)检查工作。尽管VBA似乎被简单的默认函数挂起了，但问题是我仍然有对Visio库的引用。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|351302|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

In my case I was checking work done on my office computer (with Visio installed) at home (no Visio). Even though VBA appeared to be getting hung up on simple default functions, the problem was that I had references to the Visio libraries still active.

blocks|key|3130598|text|我找到了对AVAYA/CMS程序文件的引用？完全随机，这是在MS+Access中，与AVAYA无关。我的电脑上有AVAYA，而其他人没有，所以这就解释了为什么它在我的机器上工作，而不是其他人--但不能解释Access是如何链接到AVAYA的。无论如何，我只是取消了引用的检查，这似乎已经解决了这个问题|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3130599|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I found references to an AVAYA/CMS programme file? Totally random, this was in MS Access, nothing to do with AVAYA. I do have AVAYA on my PC, and others don't, so this explains why it worked on my machine and not others - but not how Access got linked to AVAYA. Anyway - I just unchecked the reference and that seems to have fixed the problem

blocks|key|3130607|text|在我的例子中，我甚至不能在Visual+Basic窗口中打开“引用”。我甚至尝试重新安装Office+365，但都不起作用。最后，我尝试在“信任中心”设置中禁用宏。当我重新启动Excel时，我得到了宏被禁用的警告消息，当我点击“启用”时，我不再得到错误消息。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3130608|后来我重新启用了“信任中心”设置中的所有宏，错误消息没有显示！|3130609|嘿，如果其他方法都不适用于您，请尝试上面的方法；它对我有效！:)|3130610|更新：问题返回，这就是我第二次“修复”它的方式|offset|length|style|BOLD|3130611|我在Excel+online+(Office365，在浏览器中，它不支持宏)中打开我的工作簿，用一个新的文件名(仍然使用.xlsm文件扩展名)保存它，然后在桌面软件中重新打开。啊，真灵。|3130612|entityMap^0|0|0|0|0|3|0|2|C|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Q|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|S|8|@$H|T|I|U|J|K]]|9|@]|A|$]]|$1|L|3|M|5|6|7|V|8|@$H|W|I|X|J|K]]|9|@]|A|$]]|$1|N|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|O|$]]

In my case, I could not even open "References" in the Visual Basic window. I even tried reinstalling Office 365 and that didn't work. Finally, I tried disabling macros in the "Trust Center" settings. When I restarted Excel, I got the warning message that macros were disabled, and when I clicked on "enable" I no longer got the error message. 

Later I re-enabled all macros in the "Trust Center" settings, and the error message didn't show up!

Hey, if nothing else works for you, try the above; it worked for me! :)

Update: 
The issue returned, and this is how I "fixed" it the second time:

I opened my workbook in Excel online (Office 365, in the browser, which doesn't support macros anyway), saved it with a new file name (still using .xlsm file extension), and reopened in the desktop software. It worked.

blocks|key|349040|text|我断断续续地在几个XLSM文件中出现这个错误大约两年了(这是最令人恼火的，因为当它发生时，文件没有任何问题！-我怀疑孤立的Excel进程是问题的一部分)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|349041|我找到的最有效的解决方案是使用Python和oletools+https://github.com/decalage2/oletools/wiki/Install，提取所有模块的VBA代码，并保存在一个文本文件中。|offset|length|style|CODE|349042|然后，我只需将该文件重命名为zip+file+(备份以防万一！)，打开该zip文件并删除xl/vbaProject.bin文件。将其重命名为XLSX，这样就可以运行了。|349043|复制保存的VBA代码(需要清除换行符、注释和其他内容。还需要添加缺少的库。|349044|这拯救了我，而其他方法却没有。|349045|YMMV.|349046|entityMap^0|0|V|1E|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@$D|T|E|U|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|V|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|W|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|X|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|Y|8|@]|9|@]|A|$]]|$1|P|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|Q|$]]

I've had this error on and off for around two years in a several XLSM files (which is most annoying as when it occurs there is nothing wrong with the file! - I suspect orphaned Excel processes are part of the problem)
The most efficient solution I had found has been to use Python with oletools
<code>https://github.com/decalage2/oletools/wiki/Install</code> and extract the VBA code all the modules and save in a text file.
Then I simply rename the file to zip file (backup just in case!), open up this zip file and delete the xl/vbaProject.bin file. Rename back to XLSX and should be good to go.
Copy in the saved VBA code (which will need cleaning of line breaks, comments and other stuff. Will also need to add in missing libraries.
This has saved me when other methods haven't.
YMMV.

blocks|key|3130683|text|即使所有引用都正常，前缀问题也会导致编译错误。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3130684|如何为所有模块中的所有“内置VBA函数”创建查找和替换子函数，如下所示：|3130685|replace+text+in+code+module|offset|length|3130686|例如，"=+Date“将替换为"=+VBA.Date”。|3130687|例如，“Date(”将被替换为“VBA.Date(”。|3130688|(不包括"dim+t+As+Date“或"mydate")|3130689|所有用于查找和替换的vba函数都写在这里：|3130690|vba+functions+list|3130691|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/44349684/replace-text-in-code-module|1|https://bettersolutions.com/vba/functions/complete-list.htm^0|0|0|0|R|0|0|0|0|0|0|0|I|1|0^^$0|@$1|2|3|4|5|6|7|11|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|12|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|13|8|@]|9|@$F|14|G|15|1|16]]|A|$]]|$1|H|3|I|5|6|7|17|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|18|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|19|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|1A|8|@]|9|@]|A|$]]|$1|P|3|Q|5|6|7|1B|8|@]|9|@$F|1C|G|1D|1|1E]]|A|$]]|$1|R|3|-4|5|6|7|1F|8|@]|9|@]|A|$]]]|S|$T|$5|U|V|W|A|$X|Y]]|Z|$5|U|V|W|A|$X|10]]]]

Even when all references are fine the prefix problem causes compile errors.
What about creating a find and replace sub for all 'built-in VBA functions' in all modules,
like this:
<a href="https://stackoverflow.com/questions/44349684/replace-text-in-code-module">replace text in code module</a>
e.g. &quot;= Date&quot; will be replaced with &quot;= VBA.Date&quot;.
e.g. &quot; Date(&quot; will be replaced with &quot; VBA.Date(&quot; .
(excluding &quot;dim t As Date&quot; or &quot;mydate&quot;)
All vba functions for find and replace are written here :
<a href="https://bettersolutions.com/vba/functions/complete-list.htm" rel="nofollow noreferrer">vba functions list</a>

blocks|key|351356|text|对于那些还没有找到任何其他答案的人来说，这对你很有用。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|351357|试试这个：|351358|关闭文件，将其通过电子邮件发送给您自己，或者如果您正在工作，请将其从网络驱动器粘贴到您的桌面上，任何使其在“保护模式”中打开的操作。|351359|现在打开该文件|351360|不要单击任何启用编辑或黄色功能区|351361|转到VBA编辑器|351362|转到“调试--编译VBA工程”，如果“编译VBA工程”呈灰色显示，则可能需要单击一次黄色功能区才能启用内容，但不能启用宏。|351363|单击编译、保存、关闭文件后。重新打开它，启用一切，它应该是正常的。这对我来说是100%25有效的。|351364|entityMap^0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|T|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|U|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|V|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|W|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|X|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|Y|8|@]|9|@]|A|$]]|$1|P|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|Q|$]]

For those of you who haven't found any of the other answers work for you.
Try this:
Close out of the file, email it to yourself or if you're at work, paste it from the network drive to your desktop, anything to get it to open in &quot;protected mode&quot;.
Now open the file
DON'T CLICK ANY ENABLE EDITING OR THE YELLOW RIBBON
Go to the VBA Editor
Go to Debug - - Compile VBA Project, if &quot;Compile VBA Project&quot; is greyed out, then you may need to click the yellow ribbon one time to enable the content, but DO NOT enable macros.
After you click Compile, save, close out of the file. Reopen it, enable everything and it should be OK. This has worked for me 100% of the time.

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.

<ul>
<li>How do I make "VBA." implicit in my project properties/references/etc?</li>
</ul>

-Adam

"Can't find Project or Library" for standard VBA functions

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

所以我不得不在我的PC上运行别人的excel应用程序，而我在诸如日期、格式、十六进制、mid等标准函数上得到“找不到项目或库”。一些研究表明，如果我在这些函数前面加上“VBA”。就像在"VBA.Date“中那样，它就会工作得很好。网页建议它与我的系统上的项目引用有关，而它们在开发人员的系统上必须是可以的。我将从其他人那...

问标准VBA函数的“找不到项目或库”
EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问标准VBA函数的“找不到项目或库”EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问标准VBA函数的“找不到项目或库”
EN