vba Excel - “找不到文件:VBA6.DLL”

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/1296830/
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

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-09-11 10:42:44  来源:igfitidea点击:

Excel - "File Not Found: VBA6.DLL"

excelvbaexcel-vba

提问by Saobi

I have an Excel 2007 Sheet with Macros. When I click on a button, it immediately pops up an error "File Not Found: VBA6.DLL"

我有一个带有宏的 Excel 2007 工作表。当我点击一个按钮时,它立即弹出一个错误“找不到文件:VBA6.DLL”

Problem is, I have been using this sheet forever, and never seen this problem before. I did make some very very minor changes to the Macro code.

问题是,我一直在使用这张表,以前从未见过这个问题。我确实对宏代码做了一些非常非常小的改动。

And, I have 2 other sheets with identical macro code which I made the same changes to. And those two sheets run fine.

而且,我还有另外 2 张具有相同宏代码的工作表,我对其进行了相同的更改。那两张纸运行良好。

Any ideas?

有任何想法吗?

回答by Fionnuala

In this order:

按照这个顺序:

  • Check your references (Alt+F11, Tools-References) to see if any are marked MISSING and make sure that Visual Basic for Applicatiions is checked.

  • Check the directory C:\WINDOWS\system32 for VBA6.dll

  • You may need to register VBA6.dll (Start->Run)

    Regsvr32.EXE "C:\WINDOWS\system32\VBA6.dll"

  • 检查您的参考文献(Alt+F11,工具-参考文献)以查看是否有任何标记为 MISSING,并确保选中 Visual Basic for Applicatiions。

  • 检查目录 C:\WINDOWS\system32 中是否有 VBA6.dll

  • 您可能需要注册 VBA6.dll (Start->Run)

    Regsvr32.EXE "C:\WINDOWS\system32\VBA6.dll"

回答by Brian

I had the same problem with a shared file. The fix was as follows:

我在共享文件时遇到了同样的问题。修复如下:

  1. Un-share the file
  2. Copy all macros; sheets, this workbook, modules and saved them in a text format.
  3. Save the .xlsm as a .xlsx file
  4. Save back to .xlxm file
  5. Paste all macros back in
  6. Reset shortcut keys and descriptions in macro options
  7. Re-share the file
  1. 取消共享文件
  2. 复制所有宏;工作表、此工作簿、模块并将它们保存为文本格式。
  3. 将 .xlsm 保存为 .xlsx 文件
  4. 保存回 .xlxm 文件
  5. 将所有宏粘贴回
  6. 重置宏选项中的快捷键和说明
  7. 重新共享文件

This worked without having to go to IT and get someone with administrative credentials to fix it.

无需求助于 IT 部门并让具有管理凭据的人员来修复它,即可完成此操作。