vba VBE无法识别UCase,需要什么参考?
声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow
原文地址: http://stackoverflow.com/questions/13719687/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
UCase not being recognised in VBE, what reference is needed?
提问by mezamorphic
I am going through some vba code and I get a compile error on UCase(). It says compile error: can't find project or library. I have never encountered this before, what library do I need to add through references to recognise this?
我正在查看一些 vba 代码,但在 UCase() 上出现编译错误。它说编译错误:找不到项目或库。我以前从未遇到过这种情况,我需要通过引用添加什么库来识别这一点?
回答by barrowc
Check the References dialog and you should find at least one reference marked "MISSING:" Remove that missing reference and all should be well.
检查“引用”对话框,您应该至少找到一个标记为“缺少:”的引用,删除缺失的引用,一切都会正常。
Missing references can cause VBA to act strangely including not recognising built-in keywords
缺少引用会导致 VBA 行为异常,包括无法识别内置关键字
回答by Axel
If not already included you should add
如果尚未包含,则应添加
Tools -> References - > "OLE Automation"
That ist the library where UCase is available.
那就是 UCase 可用的库。