Re:Will VBA Die? (2019)
by Ididntdothis on Thursday February 27, 2020 @11:53PM
(#22440602)
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.
[ Parent
| on HN ]
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
C is a pretty low bar. And yeah, not being able to do version control, diffs, releases, dependency management... it all adds up.
I had version control and everything
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.
Re:Will VBA Die? (2019)
by pessimizer on Friday February 28, 2020 @09:27AM
(#22442966)
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.
Re:Will VBA Die? (2019)
by Ididntdothis on Friday February 28, 2020 @01:12PM
(#22444904)
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.