this post was submitted on 22 May 2024
1199 points (98.2% liked)
Memes
45661 readers
228 users here now
Rules:
- Be civil and nice.
- Try not to excessively repost, as a rule of thumb, wait at least 2 months to do it if you have to.
founded 5 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
Lol no that just summons a few demons. When you write an entire "application" in VBA and use hidden worksheets as the "database", then try to share it with the entire organization via a shared drive, then and only then will the gates of hell open and Satan himself come forth.
Oh. That explains the earthquakes.
The last application I wrote in VBA/Excel is still running 24/7 on a big screen in the command center of a company that was purchased for several billion dollars.
And yes, there are multiple database sheets. Filled with data scraped from another database. Data that was being written down on paper before I arrived and decided to learn VBA instead of develop permanent hand cramps.
But have you tried using Excel as the back end database for a poorly designed Access front end?