• 0 Posts
  • 127 Comments
Joined 2 years ago
cake
Cake day: June 11th, 2023

help-circle



  • The VBA part of the meme is real, VBA is (was?) localized. Turns out it’s a horrible idea: some keywords are badly translated, some are not translated at all. Googling localized error messages is useless, so you need to guess the original error message from the translation. Want to copy/paste a function from SO? Not so fast, you need to translate the keywords first! And the variable names as well while you’re at it.

    Ironically, you end up spending a lot of time on translation-related issues. I’ve worked on a french-VBA app, and it was a miserable experience (well, even more miserable than english VBA).












  • The point is also to minimize potential damages caused by a bug in the software. Just this year there have been multiple data-destroying bugs in publicly released software. If the app runs as a server it’s usually trivial to have it run as a dedicated user, with just enough permissions to do its job.

    It’s just good practice, even though the risks might be low why risk it at all?