Excel VBA编译错误

问题描述

我有在Windows XP下在Excel 2010中正常运行的VBA宏，但是当我尝试在Windows 10下运行它时，我收到一条错误消息，其内容如下所示...

编译错误：无法找到项目或库。

当代码调用Solver函数时出现错误。

我需要做些什么才能让宏在Windows 10下正确编译和运行？

谢谢，

杰克

解决方案

I have VBA macros that run fine in Excel 2010 under Windows XP, but when I try to run them under Windows 10 I get an error message which reads as the following...

Compile error: Can't find project or library.

The error comes up when the code makes a call to the Solver function.

What do I need to do to get the macro to compile and run correctly under Windows 10?

Thanks,

Jack

解决方案

这篇关于Excel VBA编译错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！