Comment by jl6
5 years ago
My favorite example of this was a team that needed to process more data than would fit into a normal Excel worksheet, so they wrote their application in pure VBA, reading from and writing to a custom file format, thus bypassing the Worksheet object entirely and using Excel just as a VBA runtime.
Like all such bespoke creations, it worked fine, and then the only guy who understood it left.
I've done plenty of this too.