7 ms·
.xlsx ("normal files") and .xlsm (macro-enabled files) are a series of xml files and folders stored as a zip file with their own extension. .xlsb files are bin
by froindt 7y ago
.xlsx ("normal files") and .xlsm (macro-enabled files) are a series of xml files and folders stored as a zip file with their own extension. .xlsb files are binary files, typically about 1/6 the size, and also have support of macros.
Unfortunately, regardless of save format, the VBA portion is saved in a binary format.
There are some source control systems out there for the embedded VBA code, but I haven't tried any out.
- Ididntdothis 7y agoHaving a good way for version controlling spreadsheets would go a long way. All the solutions I have seen for this are very clunky.
- froindt 7y agoI agree. Just this morning I messed up and saved over a spreadsheet I didn't mean to...no way to get that 30 minutes of work back. Probably 90% of my day is jumping between spreadsheets and queries building tools and updating reports. Spreadsheets are a "universal language" that most people understand, and allow the technically inclined business user to investigate problems without having to submit a help desk ticket and wait 4-48 hours for an answer.
- ma2rten 7y agoGoogle Sheets has a version history.