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
-
Orni10316yMother of god who decided to even make that
"I don't want to learn something new, so I guess I'll just MAKE A FULL APP IN EXCEL"
Damn -
@Orni by the looks of it I'm guessing it just grew out of control and it was never supposed to be a full app, but that's how PHP was born, right?
-
And I legit have no clue where people got that vba knowledge to begin with or how this shit came to be
-
This was a classic at my old company. Is there VBA or is it just spreadsheet functions?
-
vane110526yIt could be worse, once in my career as a developer I saw some socket server talking directly with server inside excel spreadsheet, written using vba macros.
Years after this nightmare I found such a solution on github.
So now I can give you best advice ever, use webxcel, write your server inside your excel file and let world burn ^^ -
Well I have good news and bad news for you. The good one is that the tool you are looking for exists. That bad one is that this tool is you.
-
C0D4669026yYou sir, wow, I actually pity your soul.
If it’s vba based then it shouldn’t be to hard, if it’s just functions and lookups at a cell level, your fucked 😂 -
I believe that Excel spreadsheets still rule most businesses all over the world. That's because it's extremely powerful and accessible to ask those without any programming knowledge. Excel is an awesome tool. All of which has nothing to do with when using any particular tool is advisable.
-
And that, sir, is how you sell sharepoint and office 365 by the dozen. No easier way to turn an excel spreadsheet into a website.
-
fml892276yI get the weirdness of doing a lot of business logic in excel to even make it a full app, but what are sales people gonna do?
Find somebody to walk you through it and take notes. A lot of notes. -
I have been in a similar situation where there was no documentation and I had to convert the application into a cloud app.
With patience you will find your way of getting it done one bit at a time.
The worst part is - these apps are used by different people and different teams and a bug for one person/team could be a feature for other.
Best of luck, you would need a lot of patience.. sply with those business people who doesn’t know shit about application development but will be quick to judge you as inefficient. Don’t let these people effect your morale. -
I dealt with this once. Thousands of lines of VBA. Here's what you do:
1. View VBA code
2. Take aspirin
3. Close Excel
4. Find a new project cause that's not going anywhere. -
I'm still confused why this even possible. The developers behind exc must put a considerable amount of work into making it possible to run a fucking programm written in excel. But why? Excel is for creating and using tables, scripts should only be small table manipulations. Who decided to make Excel the worst GUI-included programming environment??
-
made a post about it ages ago on here, but yeah someone made a GAME in excel, who the fuck spend so much time in x fucking l that they make a game in it.
-
kjdion843086yThis is actually kind of common. I had a guy who created his own ERP with vb macros in various excel sheets. He wanted the entire system converted to php, but also wanted his current system to feed into the same database in the meantime.
Needless to say I noped the fuck out. -
I'm actually impressed they got that going for them! I run for cover when I need to use vlookup in excel.. o.O or open one with macros..
Related Rants
-
cdrice105"You gave us bad code! We ran it and now production is DOWN! Join this bridgeline now and help us fix this!" ...
-
MoboTheHobo36My Friend: Dude our Linux Server is not working anymore! Me: What? What did you do? My friend: Nothing I swe...
-
tommy15Right now someone at Google is coding something useless for us to laugh at on April Fools.
They made a full fucking application in MICROSOFT EXCEL!!!!!!!
who the fuck makes an app in Excel? Though it's used internally, it has over 100 users and Everytime there's an update a new file is sent to all of them by mail. They use different excel files as DBs and tables as sheets. It's even got a fucking UI with check boxes and drop-downs and shit
Now guess what my task is?
Understand that entire application from the Excel files and make a webapp to cater to those requirements.
Fuck documentation, there are bugs in the Excel file and I need to fix the bugs in my app
Some good soul please tell me how must one start analyzing an Excel sheet to understand the logic behind it. Or a tool that magically converts "excel applications" to webapps
rant
excel sucks
legacy shit
fml