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