Hacker News Reader

Comment by Waterluvian | Hacker News Reader

How do you do version control with code embedded into spreadsheets? Am I not better off making code that generates a spreadsheet (or CSV or whatever formats I care about)?

View on HN

It's possible to export the code to text files. MZ-Tools [1] can do it, or use VBA directly [2]. Xtrail [3] is popular in Finance companies but I haven't used it personally

[1] https://www.mztools.com/ [2] https://www.rondebruin.nl/win/s9/win002.htm [3] https://www.xltrail.com/

It's not as pleasant as working with plaintext, but Spreadsheet Compare is a nifty tool for diffing workbooks: https://support.office.com/en-us/article/Basic-tasks-in-Spre...

Excel has this built in in the later versions (since 2013, I think)

Copy and paste the file to a new folder.

    Copy of 2019Q1-finance-report-3__fixed)_Jon edits - bugfix (2).xls.xlsx

It’s been a long time since I looked into it but I remember a version of Office like 20 years ago that integrated with version control. I wonder if that’s still a thing.

Reply on news.ycombinator.com