Visual Basic for ApplicationsRun-time error ‘53‘，Run-time error ‘5‘ 解决办法

MacOS系统，打开Microsoft Office word/powerpoint.excel 遇到以下报错

Visual Basic for Applications

Run-time error '53':

File not found: /Library/Application Support/Foxit Software/AddInPrinterUl.framework/Versions/A/

AddInPrinterUl

Run-time error '5':

Invalid procedure call or argument

在网上找到有一种治标不治本的办法，可以在开启文件时，不再报错显示：
https://apple.stackexchange.com/questions/407353/how-to-fix-run-time-error-53-every-time-i-open-a-file-in-ms-word-excel-or-powe

“

After looking really hard for a solution, I finally found in a very obscure page the answer. It is quite simple and works with the latest Microsoft Word on Big Sur:

1. Close all Office applications
2. Go to /Users/your-user-name-here/Library/Group Containers/UBF8T346G9.Office/User Content/Startup/Word
   • If the Library folder is initially hidden, press the “Command” + “Shift” + “.” (period) keys at the same time to display it.
3. Remove linkCreation.dotm
4. Restart Word and problem solved

Unfortunately that does not solve the problem for PowerPoint or Excel because if I remove SaveAsAdobePDF.ppam inside the PowerPoint folder or the SaveAsAdobePDF.xlam inside the Excel folder will trigger another error on application launch.

To fix these errors, you need to:

1. Remove the SaveAsAdobePDF.ppam and SaveAsAdobePDF.xlam from the PowerPoint and Excel folders next to the Word folder.
2. Launch Excel and PowerPoint and go to the menu Tools -> Excel Add-ins... and Tools -> PowerPoint Add-ins..., respectively, and remove the Save as Adobe PDF add-in, by unchecking it and removing it with the "-" button and then click OK.
3. Restart Excel and PowerPoint and the problem should go away. If not, try several times to remove those options from the Tools menu until the problem goes away. I had to repeat this procedure in PowerPoint until this got fixed.

”

两步解决：

1.移除/Users/your-user-name-here/Library/Group Containers/UBF8T346G9.Office/User Content/Startup里的

Word或者Powerpoint或者Excel文件夹中的：Word Addin.dotm 或者PowerPoint Addin.ppam或者Excel Addin.xlam 文件，路径找不到，在文件夹中 “Command” + “Shift” + “.” 显示隐藏路径

2.打开Word或者Powerpoint或者Excel软件，任意打开一个项目，依次点击：菜单栏，工具，加载项，取消勾选里面步骤1对应的文件。

英文路径：menu Tools -> Excel Add-ins... and Tools -> PowerPoint Add-ins...

我一开始以为是Foxit PDF阅读器的问题，error 53的报错和printer设置脱不了关系。但是找不到好的解决办法。把Foxit删掉之后出现的error53，然后把和Foxit相关的所有文件删除以后，又变成了error 5。之前还尝试过在Excel那个报错里可以Debug VB，但是最终还是会报错。

当然如果是大牛，我觉得用VB肯定有解决办法，但是实在是找不到了。感觉这个方法也凑合能用，眼不见为净，虽然还是有点强迫症。