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 0 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

    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
                                        • M Mycroft Holmes

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

                                          Never underestimate the power of human stupidity RAH

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

                                          And every day, I remind them in no uncertain terms that I hate VB.

                                          ".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
                                          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