[Ididntdothis]

Maintaining VBA code is probably easier than maintaining C code. You have all the tools to structure things nicely. You even have classes. One problem is that you can’t version control Excel or Access code. I think that’s the biggest weakness.

[fbender]

I found this gem: https://www.xltrail.com/ – I have not used it yet but from the looks it‘s a great solution to our vicious circle of (no) maintenance at work :D

[lmm]

C is a pretty low bar. And yeah, not being able to do version control, diffs, releases, dependency management... it all adds up.

[kevas]

I had version control and everything

[lmm]

What did your build/release pipeline look like? I'm imagining a lot of that would have had to be custom, just because I've never heard of this being done with VBA.

[pessimizer]

I used to use a weird excel extension that I found somewhere that would export all the modules as text and push them to a subversion repo.

[Ididntdothis]

I wrote one for Access a long time ago. Worked surprisingly well but it didn’t export queries and table definitions. Should have done that too.