News for hackers. Stuff that matters.
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.
Re:Will VBA Die? (2019) by fbender on Friday February 28, 2020 @02:05AM (#22441062)
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
Re:Will VBA Die? (2019) by lmm on Friday February 28, 2020 @05:23AM (#22441818)
C is a pretty low bar. And yeah, not being able to do version control, diffs, releases, dependency management... it all adds up.
Re:Will VBA Die? (2019) by kevas on Friday February 28, 2020 @02:02PM (#22445335)
I had version control and everything
Re:Will VBA Die? (2019) by lmm on Friday February 28, 2020 @09:45PM (#22448384)
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.