CODEWITHSUNDEEP
xmlexcelvba
dww
dww

Reputation: 31454

Location of excel vba macros in xml

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).

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

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.

Upvotes: 3

Views: 3251

Answers (1)

Axel Richter
Axel Richter

Reputation: 61945

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.

Upvotes: 7

Related Questions