读取Excel文件的VBA宏（或vbaProject.bin），而不在MS Excel中打开它 [英] Read VBA macros (or vbaProject.bin) of an Excel file without opening it in MS Excel

问题描述

我想分析Excel文件，特别是那些含有内部VBA程序。因为我打算一个一个上运行大量的Excel文件这个分析，我不想打开Microsoft Excel中的这些文件来分析它们。

I would like to analyze Excel files, especially those which contain VBA programs inside. because I plan to run this analysis on lots of Excel files one by one, I don't want to open these files within Microsoft Excel to analyze them.

困难之一是查找和分析Excel文件的VBA宏。我们知道，一个Excel文件可以被转换成 .zip文件文件，其中包含了许多的.xml 和 vbaProject.bin ，这是pretty肯定的是，VBA宏在 vbaProject.bin 。然而，问题是怎么看的？

One difficulty is to find and parse the VBA macros of an Excel file. We know that an Excel file can be converted to .zip file which contains lots of .xml and vbaProject.bin, it is pretty certain that VBA macros are in vbaProject.bin. However, the problem is how to read it?

有谁知道是否有任何工具或API来查找和分析的VBA宏？

Does anyone know if there is any tool or API to find and parse the VBA macros?

有谁知道是否有任何工具或API来读取 vbaProject.bin ？

Does anyone know if there is any tool or API to read vbaProject.bin?

推荐答案

有是微软一个非常大的PDF它说明了如何从提取功能 vbaproject.bin ：

There is a very large PDF from Microsoft which documents how to extract functions from the vbaproject.bin:

<一个href=\"http://download.microsoft.com/download/2/4/8/24862317-78f0-4c4b-b355-c7b2c1d997db/%5BMS-OVBA%5D.pdf\">http://download.microsoft.com/download/2/4/8/24862317-78f0-4c4b-b355-c7b2c1d997db/%5BMS-OVBA%5D.pdf [<一个href=\"http://answers.microsoft.com/en-us/office/forum/office_2007-customize/extract-functions-in-the-vbaprojectbin/3db716a0-fdec-4be4-a6bb-38894b0f2cea\">Source]

其可以是或可以不是免费于上述的一些其他信息：

Some additional information which may or may not be complimentary to the above:

<一个href=\"http://www.$c$cproject.com/Articles/15216/Office-2007-bin-file-format\">http://www.$c$cproject.com/Articles/15216/Office-2007-bin-file-format

这篇关于读取Excel文件的VBA宏（或vbaProject.bin），而不在MS Excel中打开它的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！