vba Excel 2010 Microsoft 表单错误无法加载某些对象，因为它们在本机上不可用
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/41596987/
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
Excel 2010 Microsoft forms error Could not load some objects because they are not available on this machine
提问by bleeetiso
I have office 2010 64 bit and I am trying to open a excel file with a userform in it that was made in office 32 bit. I get this error "Excel 2010 Microsoft forms error Could not load some objects because they are not available on this machine". then the files closes
我有 Office 2010 64 位，我正在尝试打开一个 excel 文件，其中包含在 Office 32 位中制作的用户表单。我收到此错误“Excel 2010 Microsoft 表单错误无法加载某些对象，因为它们在这台机器上不可用”。然后文件关闭
When I click the help button it says "Compile error in hidden module: module name "
当我单击帮助按钮时，它显示“隐藏模块中的编译错误：模块名称”
Is there there a way I can fix this so that I can open this file or files like this if this is a common issue?
如果这是一个常见问题，有没有办法解决这个问题，以便我可以打开这个文件或这样的文件？
thanks
谢谢
采纳答案by jkpieterse
Normally you should be able to open the file even though it generates a compile error. Can you open the file with macro's disabled? (just rename the file so Excel does not know you opened it before)
通常，即使文件产生编译错误，您也应该能够打开该文件。您可以在禁用宏的情况下打开文件吗？（只需重命名文件，以便 Excel 不知道您之前打开过它）
If so, then go to the VBA editor and check Tools, References. Note the ones markes MISSING. I bet one is something like "Common Controls". If you open the userforms you should have some empty spaces where a control used to be, those are the incompatible ones.
如果是这样，则转到 VBA 编辑器并检查工具、参考。注意那些标记为 MISSING。我敢打赌，其中一个类似于“通用控件”。如果您打开用户窗体，您应该在控件曾经所在的位置有一些空白空间，这些空间是不兼容的。
