在不打开excel的情况下读取/读取excel?-Retreiving/readingexcelmacrowithoutopeningexcel?

I wrote an excel macro that seems to have broken, unfortunately when I try to edit the macro in the VBA editor, excel itself crashes spectacularly. This seems to happen whether I open the VBA Editor before or after loading the problematic excel file.

我编写了一个excel宏，它似乎坏了，不幸的是，当我试图在VBA编辑器中编辑这个宏时，excel本身就崩溃得很厉害。这似乎是在加载有问题的excel文件之前或之后打开VBA编辑器时发生的。

Does anyone know of a way of viewing the VBA code that I've written without using excel to get there? Alternatively, can anyone get to the VBA code in (this excel file)(Link Removed) without it crashing their excel?

有谁知道不用excel就能看到我写的VBA代码吗?或者，任何人都可以在(这个excel文件)(删除了链接)中访问VBA代码而不会破坏他们的excel吗?

Unlike "Running Macros without opening excel" I don't need to be able to run the broken code without excel - just copy and paste it somewhere to fix it!

与“运行宏而不打开excel”不同，我不需要在没有excel的情况下运行损坏的代码——只需复制并粘贴到某个地方就可以修复它!

1 个解决方案