Man I hate VBA as much as the next guy, but when the IT department has your network so locked down you cant install anything. Having that hidden tab in Excel to write a script to automate some mundane task was really useful. I like python, but there’s no fuckin way my ex employer would just allow me to run random python code like they did for VBA. It was a gov job btw.
You don’t understand. “Security” is always the goto reason for either changing or leaving stuff as is, if companies don’t want to state the real reason.
People are used to ccept “Security” as a reason for almost anything.
I remember once where a MS guy (someone higher up, don’t remeber who, is many years ago…) was asked why the Windows filesystems are case-insensitive and stated the reason was security, so that one file cannot be named the same with just different upper/lowercasing letters. Classic deflection.
Man I hate VBA as much as the next guy, but when the IT department has your network so locked down you cant install anything. Having that hidden tab in Excel to write a script to automate some mundane task was really useful. I like python, but there’s no fuckin way my ex employer would just allow me to run random python code like they did for VBA. It was a gov job btw.
Python is soon to be integrated into excel, I might not be a python fan but if it’s gonna replace vba I’m all for it.
Afaik the python is ran on Microsoft servers, so not exactly a perfect solution. I doubt it will run offline at all
Wouldn’t it face the exact same security issues as VBA, with drive-by installs of obfuscated malware and executions of arbitrary code?
Can you not say that too loudly please
You don’t understand. “Security” is always the goto reason for either changing or leaving stuff as is, if companies don’t want to state the real reason.
People are used to ccept “Security” as a reason for almost anything.
I remember once where a MS guy (someone higher up, don’t remeber who, is many years ago…) was asked why the Windows filesystems are case-insensitive and stated the reason was security, so that one file cannot be named the same with just different upper/lowercasing letters. Classic deflection.
deleted by creator
deleted by creator
Not to mention Python’s in cloud