439
submitted 10 months ago by throws_lemy@lemmy.nz to c/technology@lemmy.world
you are viewing a single comment's thread
view the rest of the comments
[-] bulwark@lemmy.world 110 points 10 months ago

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.

[-] Willem@kutsuya.dev 50 points 10 months ago

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.

[-] Phen@lemmy.eco.br 54 points 10 months ago

It'll only run on cloud. Their employer would probably block that too.

[-] __ghost__@lemmy.ml 35 points 10 months ago

Afaik the python is ran on Microsoft servers, so not exactly a perfect solution. I doubt it will run offline at all

[-] aev 10 points 10 months ago

Wouldn't it face the exact same security issues as VBA, with drive-by installs of obfuscated malware and executions of arbitrary code?

[-] geophysicist@discuss.tchncs.de 6 points 10 months ago

Can you not say that too loudly please

[-] cmhe@lemmy.world 4 points 10 months ago

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.

[-] WaterWaiver@aussie.zone 9 points 10 months ago* (last edited 10 months ago)

The article is not about VBA, it's about VBS. The languages are similar but not the same (why exactly MS did it this way I'll never know).

VBA is for embedded macros in MS Office documents.

VBS is a standalone language you write into .vbs files that get executed by wscript.exe. It's a default windows feature that has been around a long time (IIRC the ILOVEYOU worm used it).

[-] Aatube@kbin.social 2 points 10 months ago

Not to mention Python’s in cloud

this post was submitted on 11 Oct 2023
439 points (98.9% liked)

Technology

57226 readers
4652 users here now

This is a most excellent place for technology news and articles.


Our Rules


  1. Follow the lemmy.world rules.
  2. Only tech related content.
  3. Be excellent to each another!
  4. Mod approved content bots can post up to 10 articles per day.
  5. Threads asking for personal tech support may be deleted.
  6. Politics threads may be removed.
  7. No memes allowed as posts, OK to post as comments.
  8. Only approved bots from the list below, to ask if your bot can be added please contact us.
  9. Check for duplicates before posting, duplicates may be removed

Approved Bots


founded 1 year ago
MODERATORS