Learn More
Resend Email
49
ComradeBob
7y

VBA is not the language of choice for many of you. But in a big non-software company, Excel is tool numero uno, and VBA saves so much time. Almost nobody bothers to learn it, which drives me nuts already, but those who learn it, suck.
Wrote a beautiful VBA script with SQL inside to fill in excelsheets automatically.

Why the living fucks would someone go in the code and alter it? Why do you ignorant idiot with almost no excel and vba knowledge alter the range of the for loop and delete a few lines.
After that completely knocked out the file, I got a call for help. "¡Your code broke!"

These useless morons.

rant

vba

ignorance
Favorite
Ranter
Comments
  • 3
    7y
    Dont ever share code with non-programming colleagues
  • 3
    7y
    Welcome Bob, nice first rant!

    Vba is a bastard but incredibly useful.
  • 3
    7y
    I hate VBA as much as the next person, but it’s cut hours of work out of my day so it’s useful if your stuck using excel.
  • 1
    7y
    Thank you Comrade @CWins !
  • 1
    7y
    I got my start in VBA, it's an awesome tool for certain problems.

    And I completely feel your pain 😄
  • 5
    7y
    I hate VBA, once I had to automate a really tedious task in excel so I made a java program to read the excel, do everything and spit out a new excel 😂
  • 1
    7y
    @azous
    I hope some day they replace it with net.Core.
  • 1
    7y
    @azous me too lol
  • 0
    7y
    @dontbeevil Oh my. That would be awesome.
  • 0
    7y
    Everything I once knew about VBA I already forgot, thank God.
    Had to code a quick excel password breaker this week to help a friend though 😄
    I rather parse the excel file with an external program and produce a new one.
  • 0
    7y
    @nbamaral That's like an order of magnitude more work tho ☺️
  • 0
    7y
    @Froot
    Yes and no: we use a lot of Excel files as a quick and dirty database, no fancy calculations and formulas, just a colorful table to paste data.
    This way the all file is validated for errors and formatted cleanly. Wouldn't do it for a financial excel, it would be a pain to code 😛
  • 1
    7y
    @nbamaral Ah right. Then it makes sense.
  • 0
    7y
    @Froot ms office.js api
    https://dev.office.com/docs/...
  • 0
    7y
    @nbamaral How did you do the password breaker? Just a C++/whatever program that sends input and bruteforce it?
  • 0
    7y
    @ComradeBob
    Nope, just VBA. It cycles all possible chars and exits on first usable password. Mind you it was a legacy excel file. Easy to found online similar code.
Related Rants
devRant © 2021 Hexical Labs LLC
Privacy Policy  |  Terms of Service
Add Comment