Ranter
Join devRant
Do all the things like
++ or -- rants, post your own rants, comment on others' rants and build your customized dev avatar
Sign Up
Pipeless API
From the creators of devRant, Pipeless lets you power real-time personalized recommendations and activity feeds using a simple API
Learn More
Comments
-
C0D4669527yI 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.
-
Froot75397yI got my start in VBA, it's an awesome tool for certain problems.
And I completely feel your pain π -
hell165967yI 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 π
-
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. -
@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 π -
@nbamaral How did you do the password breaker? Just a C++/whatever program that sends input and bruteforce it?
-
@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
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