Excel VBA宏在xml中的位置 [英] Location of excel vba macros in xml

问题描述

我有一个.xlsm格式的excel(2013)电子表格(包含vba宏)，我希望将其转换为.xml(以非专有格式保存在存储库中，并提供版本控制，例如分支的自动合并)在git中).

I have a .xlsm format excel (2013) spreadsheet (containing vba macros) that I wish to convert to .xml (to save in a non-proprietary format in a repository, and to provide version control e.g. automated merging of branches in git).

此处和此处，<将c0>文件压缩为xml，因此只需将其解压缩即可将其转换.

As explained here and here, .xlsx files are zipped xml, so they can be converted by simply unzipping.

我使用启用了宏的.xlsm文件尝试了此操作，但确实获得了电子表格的xml结构.但是我在任何地方都找不到宏.有谁知道宏存储在.xlsm中的位置以及在相应的未压缩文件夹中的哪里可以找到它们.

I tried this with a macro-enabled .xlsm file, and I do get an xml structure of the spreadsheet. But I can't find the macros anywhere. Does anyone know where the macros are stored in .xlsm and where to find them in the corresponding unzipped folder.

推荐答案

如果将*.xslm解压缩，则会在ZIP存档中找到/xl/vbaProject.bin.这是包含宏的二进制文件.

If you unzip the *.xslm you will find a /xl/vbaProject.bin within the ZIP archive. This is the binary file which contains the macros.

这篇关于Excel VBA宏在xml中的位置的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！