Excel-VBA horror stories

Have you ever worked for a company who for some reasons never switched to traditional SQL, Data Warehouses etc... and massively used horrendous Excel VBA queries for data queries?

I remember one company I worked for had SQL but it was heavily "defended" from the IT and the BI department never pushed for it (maybe also because nobody knew it apart of me). There was a VBA query for everything, and they were horrendous, horrible, slow,... English is not my …

datascience excel horror