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.