Excel VBA:找不到项目或库 [英] Excel VBA: Can't find project or library

问题描述

运行Windows 10 Microsoft Excel 16 64位

Running Windows 10 Microsoft Excel 16 64 bit

仅遇到此问题-使用少量VBA编码打开普通文件.

Just encountered this issue - Opening a normal file with a small amount of VBA coding.

今天打开文件时，遇到错误找不到项目或库"

On opening file today, ran into error "Can't find project or library"

错误出现在几个文件中，并且在重新启动后被本地化为单个文件.

Error appeared in a few files, and after restarting was localized to a single file.

推荐答案

步骤:

1. 恐慌
2. 修复后的Microsoft Office
3. 从XLStart中删除了personal.xlsb文件进行测试
4. 打开空白excel，Alt + F11打开VBA
5. 工具->参考->对象库
6. 搜索丢失的物体
7. 已更正
8. 这些步骤无法解决，因此重命名了在安全模式下打开的文件(win + R类型Excel.exe/safe)
9. 更新日期，更改了一些项目并保存
10. 已正常打开文件，问题已解决.

1. panic
2. Repaired Microsoft Office
3. removed personal.xlsb file from XLStart to test
4. Opened blank excel, Alt + F11 to open VBA
5. Tools -> References -> Object Library
6. Search for missing objects
7. Corrected if found
8. These steps didn't resolve, so renamed the file opened in safe mode (win + R type Excel.exe /safe)
9. Updated dates, changed a few items and saved
10. Opened file normally, issue resolved.

或者，尝试让其他人打开文件/更新名称并为您更改一些内容.该文件可能已损坏

Alternatively, try to have someone else open the file/update name and change a few things for you. the file is likely corrupt

这篇关于Excel VBA:找不到项目或库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！