close

Privacy guaranteed - Your email is not shared with anyone.

VBA (Visual Basic for Applications) is awful

Discussion in 'The Okie Corral' started by devildog2067, Aug 6, 2012.

  1. devildog2067

    devildog2067

    Joined:
    Apr 20, 2005
    Messages:
    16,413
    Likes Received:
    1,350
    Location:
    Chicago
    Slow, clunky, treats me like I'm an idiot. And all of my C++ habits are wrong.

    Why, WHY can't I code up Excel applications in a real language without having to use external .dll or .xll?
     
  2. Mr Spock

    Mr Spock Vulcan

    Joined:
    Jan 6, 2008
    Messages:
    1,174
    Likes Received:
    0
    If Microsoft had a hand in C++ it would have sucked just as bad.
     

  3. HerrGlock

    HerrGlock Scouts Out CLM

    Joined:
    Dec 28, 2000
    Messages:
    23,796
    Likes Received:
    212
    The only time MS would make a product that didn't suck is if they started manufacturing vacuum cleaners.
     
  4. Mr Spock

    Mr Spock Vulcan

    Joined:
    Jan 6, 2008
    Messages:
    1,174
    Likes Received:
    0
    You're right. Then, it would blow.
     
  5. Glock20 10mm

    Glock20 10mm Use Linux!

    Joined:
    Dec 26, 2005
    Messages:
    15,175
    Likes Received:
    620
    Location:
    Land of Idiots and Libtards
    Welcome to WHY I left the Microsoft world and work exclusively in the Linux world.
     
  6. aspartz

    aspartz

    Joined:
    Oct 19, 2000
    Messages:
    3,281
    Likes Received:
    133
    Location:
    Sandstone, MN 55072
    C++ Does suck that bad. There is very little that is better about the "++" than regular C. Operator overloading is the only thing I can think of...

    Then again, I cut my teeth on assembly language. Objects make no sense to my brain.

    ARS
     
    Last edited: Aug 6, 2012
  7. ron59

    ron59 Bustin Caps

    Joined:
    Jan 3, 2009
    Messages:
    6,927
    Likes Received:
    22
    Location:
    Smyrna, GA
    That's why C# is the big thing these days.
    I don't see any job offers for C++, but C# (or VB.NET) is pretty big.
     
  8. Geko45

    Geko45 Smartass Pilot CLM

    Joined:
    Nov 1, 2002
    Messages:
    18,220
    Likes Received:
    2,048
    Location:
    KCXO
    They still found a way to ruin it in Visual C++. MFC was/is an abomination.
     
  9. cowboy1964

    cowboy1964

    Joined:
    Sep 4, 2009
    Messages:
    22,769
    Likes Received:
    4,407
    Location:
    U.S.A.
    Wasn't Linux supposed to have won the desktop war like, 10 years ago?

    Check back in another 10 or 20.
     
    Last edited: Aug 6, 2012
  10. cowboy1964

    cowboy1964

    Joined:
    Sep 4, 2009
    Messages:
    22,769
    Likes Received:
    4,407
    Location:
    U.S.A.
    Wonder how many CS grads today would even understand the concept of pointers, let alone double indirection?
     
  11. devildog2067

    devildog2067

    Joined:
    Apr 20, 2005
    Messages:
    16,413
    Likes Received:
    1,350
    Location:
    Chicago
    I need a data structure:

    map <string, customType>

    where the customType is a struct that contains 3 strings and a vector of pair<string, int>

    Yeah, can't really be done in VBA. The dictionary data type is similar to but not the same as map. There's no vector type. There's no pair type.
     
  12. Glock20 10mm

    Glock20 10mm Use Linux!

    Joined:
    Dec 26, 2005
    Messages:
    15,175
    Likes Received:
    620
    Location:
    Land of Idiots and Libtards
    To me it doesn't matter who "won the desktop war" what matters are the following:

    1. Ease of use - Check
    2. Affordable - Check
    3. Reliable - Check
    4. High resistance to virus attack - Check
    5. Ease of programming - Check
    6. Availability of cost effective programming environments - Check

    While I may come of sounding as though it's a "religion" to me, it's not. For me Linux is a cost effective, reliable, scalable, secure and robust system that allows me to be effective in my job. Every time I use a Microsoft Windows system it feels as though I am fighting the stupid computer to get my job done.
     
  13. Detectorist

    Detectorist

    Joined:
    Jul 16, 2008
    Messages:
    17,073
    Likes Received:
    6,275
    Location:
    Missouri
    What, exactly, are you trying to do? Why is a PhD doing his own basic programming?
     
  14. devildog2067

    devildog2067

    Joined:
    Apr 20, 2005
    Messages:
    16,413
    Likes Received:
    1,350
    Location:
    Chicago
    What the client decided they wanted.

    I basically did nothing but wrote code for all of grad school. Writing code is basically all that particle physicists do, grad students up to tenured professors up to Nobel Prize winners.
     
  15. Detectorist

    Detectorist

    Joined:
    Jul 16, 2008
    Messages:
    17,073
    Likes Received:
    6,275
    Location:
    Missouri
    Yea, it was. It will never be ready for the masses until there is one unified version and support mechanism.
     
  16. Detectorist

    Detectorist

    Joined:
    Jul 16, 2008
    Messages:
    17,073
    Likes Received:
    6,275
    Location:
    Missouri
    Wow, I didn't know that.