55

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

Comments
  • 19
    Mother 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
  • 12
    I'm sorry brother.
    Stay strong and may the spreadsheet gods be with you.
  • 8
    @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?
  • 5
    @lucaspar That's probably true, but now here we are.

    I've never actually used PHP, but I doubt it's as bad as an ENTIRE app made in Excel
  • 1
  • 3
    I guess the vb scripts are a starting point but I putty your soul.
    Good luck!
  • 1
    @xzvf It doesn't even use VBA or macros according to the description
  • 3
    And I legit have no clue where people got that vba knowledge to begin with or how this shit came to be
  • 1
    This was a classic at my old company. Is there VBA or is it just spreadsheet functions?
  • 3
    It 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 ^^
  • 2
    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.
  • 8
    It‘s called enterprise software!
  • 1
    You 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 😂
  • 1
    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.
  • 0
    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.
  • 0
    I 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.
  • 0
    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.
  • 1
    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.
  • 1
    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??
  • 0
    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.
  • 1
    This 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.
  • 0
    @Alice You forgot to add refrigerators and 1950s main frames
  • 1
    Thank you all for the support but it's not VB it's fucking Excel formulae! FML😭
  • 0
    DISGUSTING
  • 1
  • 0
    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..
Add Comment