Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. The Lounge
  3. So I gave a dev a choice yesterday

So I gave a dev a choice yesterday

Scheduled Pinned Locked Moved The Lounge
csharpcollaborationcareer
89 Posts 40 Posters 1 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • M Mycroft Holmes

    We had a requirement that needed someone to write some VBA macros in Excel (2003) yesterday, both devs on the team denied any knowledge of VB/VBA/VB.Net I gave them a choice of doing the job in VBA or documentation, we should have some great manuals for this project. I was astonished that a person who calls himself a developer has no knowledge of office or macro programming, I thought we all got dipped in that stuff at some time.

    Never underestimate the power of human stupidity RAH

    G Offline
    G Offline
    Gary R Wheeler
    wrote on last edited by
    #20

    The folks in my group would have jumped on the VBA project. The sissies hate writing and generally refuse to do it. I write practically all of the documentation for the group.

    Software Zen: delete this;

    1 Reply Last reply
    0
    • M Mycroft Holmes

      We had a requirement that needed someone to write some VBA macros in Excel (2003) yesterday, both devs on the team denied any knowledge of VB/VBA/VB.Net I gave them a choice of doing the job in VBA or documentation, we should have some great manuals for this project. I was astonished that a person who calls himself a developer has no knowledge of office or macro programming, I thought we all got dipped in that stuff at some time.

      Never underestimate the power of human stupidity RAH

      L Offline
      L Offline
      Lost User
      wrote on last edited by
      #21

      Major disconnect. Would you ask your proctologist to clean your teeth? They're probably both looking at job sites as I write this ...

      M 1 Reply Last reply
      0
      • L Lost User

        Major disconnect. Would you ask your proctologist to clean your teeth? They're probably both looking at job sites as I write this ...

        M Offline
        M Offline
        Mycroft Holmes
        wrote on last edited by
        #22

        Rene Pilon wrote:

        They're probably both looking at job sites as I write this ...

        Hmmm one of them is not in this morning - suspicious... If you think as a developer you will not be required to write doco then you will be sadly disappointed. In most (all) corporate shops there is no such thing as a technical writer, the closest I have seen is where we have hired an agency to to this.

        Never underestimate the power of human stupidity RAH

        L 2 Replies Last reply
        0
        • M Mycroft Holmes

          Rene Pilon wrote:

          They're probably both looking at job sites as I write this ...

          Hmmm one of them is not in this morning - suspicious... If you think as a developer you will not be required to write doco then you will be sadly disappointed. In most (all) corporate shops there is no such thing as a technical writer, the closest I have seen is where we have hired an agency to to this.

          Never underestimate the power of human stupidity RAH

          L Offline
          L Offline
          Lost User
          wrote on last edited by
          #23

          Caught the ruse after I hit the post button... Good one :laugh: p.s been coding and writing docs for years...

          I 1 Reply Last reply
          0
          • M Mycroft Holmes

            Rene Pilon wrote:

            They're probably both looking at job sites as I write this ...

            Hmmm one of them is not in this morning - suspicious... If you think as a developer you will not be required to write doco then you will be sadly disappointed. In most (all) corporate shops there is no such thing as a technical writer, the closest I have seen is where we have hired an agency to to this.

            Never underestimate the power of human stupidity RAH

            L Offline
            L Offline
            Lost User
            wrote on last edited by
            #24

            Mycroft Holmes wrote:

            write doco

            Sorry? Doco? Documentation? Developers are (mostly) the worst document writers in the known universe.

            ___________________________________________ .\\axxx (That's an 'M')

            R 1 Reply Last reply
            0
            • L Lost User

              Mycroft Holmes wrote:

              write doco

              Sorry? Doco? Documentation? Developers are (mostly) the worst document writers in the known universe.

              ___________________________________________ .\\axxx (That's an 'M')

              R Offline
              R Offline
              Rob Graham
              wrote on last edited by
              #25

              _Maxxx_ wrote:

              Developers are (mostly) the worst document writers in the known universe.

              Indeed. And it's a hard won skill,too.

              "People who bite the hand that feeds them usually lick the boot that kicks them." Eric Hoffer "The failure mode of 'clever' is 'asshole'" John Scalzi

              1 Reply Last reply
              0
              • D Dalek Dave

                I would not hire anybody who denied VBA!

                ------------------------------------ I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave CCC Link[^] Trolls[^]

                H Offline
                H Offline
                H Brydon
                wrote on last edited by
                #26

                You wouldn't hire me. I wouldn't let you. I've actually programmed about 2000 lines of it but I disavow any knowledge of it (except for here of course). ;P I know about 100 programming languages and vba is one I'm happy to put behind me.

                M I 2 Replies Last reply
                0
                • M Mycroft Holmes

                  We had a requirement that needed someone to write some VBA macros in Excel (2003) yesterday, both devs on the team denied any knowledge of VB/VBA/VB.Net I gave them a choice of doing the job in VBA or documentation, we should have some great manuals for this project. I was astonished that a person who calls himself a developer has no knowledge of office or macro programming, I thought we all got dipped in that stuff at some time.

                  Never underestimate the power of human stupidity RAH

                  L Offline
                  L Offline
                  leppie
                  wrote on last edited by
                  #27

                  Mycroft Holmes wrote:

                  both devs on the team denied any knowledge of VB/VBA/VB.Net

                  Same here. What is this VB thing exactly?

                  ((λ (x) `(,x ',x)) '(λ (x) `(,x ',x)))

                  1 Reply Last reply
                  0
                  • D Dalek Dave

                    Ah yes a C64, a machine that was almost as good as a ZX Spectrum, and yet 5 times the size.

                    ------------------------------------ I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave CCC Link[^] Trolls[^]

                    B Offline
                    B Offline
                    Brady Kelly
                    wrote on last edited by
                    #28

                    Haha, yes.

                    1 Reply Last reply
                    0
                    • H H Brydon

                      You wouldn't hire me. I wouldn't let you. I've actually programmed about 2000 lines of it but I disavow any knowledge of it (except for here of course). ;P I know about 100 programming languages and vba is one I'm happy to put behind me.

                      M Offline
                      M Offline
                      Mike Winiberg
                      wrote on last edited by
                      #29

                      Aside from all the arguments about the faults with VBA, I really don't understand the antipathy towards it (other than from a language design POV). At the end of the day (and I don't want to rekindle the religious language wars here!) a programming language (however good or bad) is a tool - you can do a good (or bad) job with it regardless of its nature. For lots of scenarios, using the built-in (ie VBA) when producing something for a client in Access or Excel makes much more sense than developing a full-on, multi-user, mathematically proven system based around MS SQL on Server 2008 using C#/LINQ etc, especially when all they wanted was automated production of a report based on a few figures in a spreadsheet. As my father used to say: "A bad workman always blames his tools..." 8) There's far too much "over-engineering" in the software development world, it seems to me...

                      D L F 3 Replies Last reply
                      0
                      • M Mycroft Holmes

                        We had a requirement that needed someone to write some VBA macros in Excel (2003) yesterday, both devs on the team denied any knowledge of VB/VBA/VB.Net I gave them a choice of doing the job in VBA or documentation, we should have some great manuals for this project. I was astonished that a person who calls himself a developer has no knowledge of office or macro programming, I thought we all got dipped in that stuff at some time.

                        Never underestimate the power of human stupidity RAH

                        R Offline
                        R Offline
                        Rage
                        wrote on last edited by
                        #30

                        Mycroft Holmes wrote:

                        has no knowledge of office or macro programming

                        Well this is possible, but programming office macro is so easy that a real programmer can do anything in real short time.

                        1 Reply Last reply
                        0
                        • M Mycroft Holmes

                          We had a requirement that needed someone to write some VBA macros in Excel (2003) yesterday, both devs on the team denied any knowledge of VB/VBA/VB.Net I gave them a choice of doing the job in VBA or documentation, we should have some great manuals for this project. I was astonished that a person who calls himself a developer has no knowledge of office or macro programming, I thought we all got dipped in that stuff at some time.

                          Never underestimate the power of human stupidity RAH

                          S Offline
                          S Offline
                          Stefan_Lang
                          wrote on last edited by
                          #31

                          The closest I ever came to VB/VBA/.NET were my (partially successful) attempts at integrating Excel table views in an application using OLE2, some 15 years ago. It was a nightmare, as all variables were declared 'Variant'. and there was no explanation at all anywhere in the documentation that told me what actual types were expected, what each parameter meant, and in what order they were supposed to be passed. There weren't even parameter names in the documentation that you could base an educated guess on, it was just trial and error! Note that I was using both the official documentation (i. e. the Excel help files) and a pair of very insightful 'behind the scenes' books about OLE2, but as I said, there were no parameter level explanations to be found anywhere at the time! Not to mention that quite a few functions weren't defined as described in the documentation, were varying dependend on the actual OS version, or delivered different results. Based on that experience you can imagine I avoided any successor of that abomination like the plague, be it COM, VBA, or .NET. (and sorry: anything that got 'Basic' in its name isn't considered a programming language by me) I realize that the documentation and the stability of the interface got to have improved in the meantime, but I still nourish a strong loathing for anything in that direction. Thankfully I was never required to touch any of this again, not even with a hot poker. So no, I do not have any knowledge of VB(A)/.NET either. I've programmed in C++ when compiling still required two steps and templates weren't fully supported, long before the time of OLE and it's successors, and I'm still programming in C++ today, knowing that most of today's C++ programs could be compiled with compilers written 20 years ago. Call me conservative if you want to, but I don't like proprietary, platform dependend languages that change every time time the OS or Office version changes.

                          R 1 Reply Last reply
                          0
                          • M Mycroft Holmes

                            We had a requirement that needed someone to write some VBA macros in Excel (2003) yesterday, both devs on the team denied any knowledge of VB/VBA/VB.Net I gave them a choice of doing the job in VBA or documentation, we should have some great manuals for this project. I was astonished that a person who calls himself a developer has no knowledge of office or macro programming, I thought we all got dipped in that stuff at some time.

                            Never underestimate the power of human stupidity RAH

                            K Offline
                            K Offline
                            KramII
                            wrote on last edited by
                            #32

                            You've obviously got two smart devs working for you!

                            KramII

                            1 Reply Last reply
                            0
                            • M Mycroft Holmes

                              We had a requirement that needed someone to write some VBA macros in Excel (2003) yesterday, both devs on the team denied any knowledge of VB/VBA/VB.Net I gave them a choice of doing the job in VBA or documentation, we should have some great manuals for this project. I was astonished that a person who calls himself a developer has no knowledge of office or macro programming, I thought we all got dipped in that stuff at some time.

                              Never underestimate the power of human stupidity RAH

                              L Offline
                              L Offline
                              Lost User
                              wrote on last edited by
                              #33

                              Mycroft Holmes wrote:

                              I was astonished that a person who calls himself a developer has no knowledge of office or macro programming

                              I worked on a team where only one member (me) out of six knew anything about VBA.

                              I must get a clever new signature for 2011.

                              M 1 Reply Last reply
                              0
                              • L Lost User

                                Mycroft Holmes wrote:

                                I was astonished that a person who calls himself a developer has no knowledge of office or macro programming

                                I worked on a team where only one member (me) out of six knew anything about VBA.

                                I must get a clever new signature for 2011.

                                M Offline
                                M Offline
                                Mycroft Holmes
                                wrote on last edited by
                                #34

                                It turns out my PM/BA has some experience so I'll dump the initial bits on her and the junior can bloody well take over from there. As someone else stated, any developer should be able to pick up VBA macros very quickly.

                                Never underestimate the power of human stupidity RAH

                                1 Reply Last reply
                                0
                                • C Christian Graus

                                  I've done some VB.NET and a smattering of VB6. I've never, ever, done VBA.

                                  Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

                                  D Offline
                                  D Offline
                                  Dave Parker
                                  wrote on last edited by
                                  #35

                                  From memory (haven't used it in ages) I don't think it's much different from VB6, not exactly the best environment to work in but nowhere near as bad as VBScript. At least you can still use option explicit and keep some sanity.

                                  1 Reply Last reply
                                  0
                                  • M Mycroft Holmes

                                    We had a requirement that needed someone to write some VBA macros in Excel (2003) yesterday, both devs on the team denied any knowledge of VB/VBA/VB.Net I gave them a choice of doing the job in VBA or documentation, we should have some great manuals for this project. I was astonished that a person who calls himself a developer has no knowledge of office or macro programming, I thought we all got dipped in that stuff at some time.

                                    Never underestimate the power of human stupidity RAH

                                    R Offline
                                    R Offline
                                    realJSOP
                                    wrote on last edited by
                                    #36

                                    I've never done office macros...

                                    ".45 ACP - because shooting twice is just silly" - JSOP, 2010
                                    -----
                                    You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
                                    -----
                                    "Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass." - Dale Earnhardt, 1997

                                    M 1 Reply Last reply
                                    0
                                    • R realJSOP

                                      I've never done office macros...

                                      ".45 ACP - because shooting twice is just silly" - JSOP, 2010
                                      -----
                                      You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
                                      -----
                                      "Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass." - Dale Earnhardt, 1997

                                      M Offline
                                      M Offline
                                      Mycroft Holmes
                                      wrote on last edited by
                                      #37

                                      Yeah but they dipped you in VB.Net if I recall.

                                      Never underestimate the power of human stupidity RAH

                                      R 1 Reply Last reply
                                      0
                                      • M Mycroft Holmes

                                        We had a requirement that needed someone to write some VBA macros in Excel (2003) yesterday, both devs on the team denied any knowledge of VB/VBA/VB.Net I gave them a choice of doing the job in VBA or documentation, we should have some great manuals for this project. I was astonished that a person who calls himself a developer has no knowledge of office or macro programming, I thought we all got dipped in that stuff at some time.

                                        Never underestimate the power of human stupidity RAH

                                        S Offline
                                        S Offline
                                        Slobos
                                        wrote on last edited by
                                        #38

                                        Programming in VBA is very useful. I did some for ACAD, Word and Excel. It's easy, all you have to do is press F1 and learn few new commands. Still, overworked people can't do that. Or people that use drugs. Or people that hate their bosses for some reason. Or just too comfortable and arrogant people...

                                        I like being sober. It gives some kind of quality to life that I can't really put my finger on... it is like running life from console way less colors but so much more control.

                                        L 1 Reply Last reply
                                        0
                                        • D Dalek Dave

                                          I would not hire anybody who denied VBA!

                                          ------------------------------------ I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave CCC Link[^] Trolls[^]

                                          S Offline
                                          S Offline
                                          Slacker007
                                          wrote on last edited by
                                          #39

                                          Dalek Dave wrote:

                                          I would not hire anybody who denied VBA!

                                          I am a VBA guru. I don't look at VBA as bad but as a tool for the job. I unlike most others, started with VBA and VB. Then moved to C++, and C#, etc... If you hate VBA just because it is VBA then you are retarded and on my team you would be a waste of everyone's time. We have to work with VBA from time to time so it is par for the course.

                                          D M 2 Replies Last reply
                                          0
                                          Reply
                                          • Reply as topic
                                          Log in to reply
                                          • Oldest to Newest
                                          • Newest to Oldest
                                          • Most Votes


                                          • Login

                                          • Don't have an account? Register

                                          • Login or register to search.
                                          • First post
                                            Last post
                                          0
                                          • Categories
                                          • Recent
                                          • Tags
                                          • Popular
                                          • World
                                          • Users
                                          • Groups