So I gave a dev a choice yesterday
-
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
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 -
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, 1997Yeah but they dipped you in VB.Net if I recall.
Never underestimate the power of human stupidity RAH
-
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
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.
-
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.
-
Yeah but they dipped you in VB.Net if I recall.
Never underestimate the power of human stupidity RAH
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 -
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
I've done a bit of tinkering with macros in excel, but it was very basic stuff. I wouldn't claim to have any knowledge of VBA. I'm astonished that both your devs picked documentation over writing code. I'd be jumping at the excel macros to avoid doing documentation. [edit]Ok maybe we need a sarcasm smiley? (maybe we have one that I'm not aware of?)[/edit]
Pete
-
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:laugh: :laugh: I do the same for Orable,
did I mention I hate Orablethis is said at least 5 times a day.Never underestimate the power of human stupidity RAH
-
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
Hmmm, there seems to be many who feel that a useful, time-saving, tool is beneath them. I can never understand this. I use VBA all the time, in Excel, Word, Project, and PowerPoint. I've used VBA to zip files or add to zip files. I've used VBA to temporarily replace one's hosts file to test a new server rather then to inflict it on everyone before it was tested. This removed any possible user problems with those who don't understand the format and function of the hosts file and eliminated the need to develop 1-time documentation to update DNS references in the file. VBA was also used to return the file to it's original state. I've cut code in Adpac, COBOL, Easytrieve, Ramis, PL1, Fortran, Rexx, Focus, VB, VB.Net, JavaScript,and other languages and have used IDMS, IMS, DB2, Access, Oracle, SQL server, MySQL and other DBMS tools. I've used mainframe JCL to establish a TSO session which launched a Clist to open a file. The Clist then launched an Edit macro to parse that file out into sub-files and then use the IBM Send Utility to send the individual files to users that were identified in the data. I completed a project estimated to take over 2000 hours in 70 hours by using the COBOL Report Writer. All these were tools used to solve a business problem. It seems to me that to discount the use of a tool that can easily solve business problems and can do so quickly is optical rectosis. It's as bad as insisting that online CICS screens be modified to pull 2 disparate IMS databases together when a few "on request" reports will do the job in a very small fraction of the time. I'd say that one will just become a more valuable asset to a firm if one delves into VBA and other tools designed to save time and solve problems. This is FAR better than to stubbornly insist that these tools are beneath the hallowed opinions you have of yourselves. LOL
modified on Friday, February 18, 2011 3:24 PM
-
I've done a bit of tinkering with macros in excel, but it was very basic stuff. I wouldn't claim to have any knowledge of VBA. I'm astonished that both your devs picked documentation over writing code. I'd be jumping at the excel macros to avoid doing documentation. [edit]Ok maybe we need a sarcasm smiley? (maybe we have one that I'm not aware of?)[/edit]
Pete
Peter Mulholland wrote:
I'd be jumping at the excel macros to avoid doing documentation.
Yep, chew the leg off rather than doco, I have so many creative ways to get out of doco I have not needed to delegate it for some time.
Never underestimate the power of human stupidity RAH
-
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
A lot of devs sneer at VBA, but that's mainly because they've never seen just how bluddy useful it can be to people who USE COMPUTERS, rather than spend all their computer-time writing code or playing games. Mind you, finding a dev who can edit a document in a word-processor without screwing the settings/structure/formats up is like finding gold in your bathroom, so finding one who has had experience in making documents even more useful/functional through judicious use of VBA won't be so easy. That said, any dev who says he won't be able to work with VBA, one of the easiest languages to program in, shouldn't be allowed to work with any of the "more difficult" languages until he's proven his mastery of VBA.
I wanna be a eunuchs developer! Pass me a bread knife!
-
The last BASIC I did was on a Commodore 64.
Every man can tell how many goats or sheep he possesses, but not how many friends.
ChrisElston wrote:
The last BASIC I did was on a Commodore 64.
For me, it was a TI-99/4A - good old TI-Basic! :-D
-
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
If you prefer Python you could do anything you can in VBA with PyXLL (www.pyxll.com)
-
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
VBA is where I started programming on the Windows platform. After watching people needlessly re-entering the same data over and over in Excel, and believe it or not I saw people using a calculator to add up the entries in a spreadsheet. They were trying to “train me” on the tracking system doing it this way. After one day, I found that all this tedious mind numbing data entry and calculation was really all just a way for them to make pretty print outs for other people to use to enter the same data into another spreadsheet. I started by recording macros and digging into them and automating them. I could do in 15 minutes what would take them a day and a half to complete and it looked better. I got a $500 spot award for doing this. I was hooked on VBA. I am with a lot of the other posters here, I don’t understand the hatred for VB and it’s variants. It is a very useful tool in the hands of someone who understands how to use it, just like any other programming language. The only problem I do see with it is the very forgiving nature of VB when it comes to variant types, mistakes can be very easily made when mixing and matching types. (I do occasionally take advantage of this when it comes to string handling, everyone knows what a pain it is converting string types in C/C++) . I have seen abuses in every language, the posts I see here in the forums every day reveal some of the finest displays of programming ignorance ever presented but luckily there are just as many bright wonderful folks who are willing to set them straight that’s why I come here. :) My 2cents.
It was broke, so I fixed it.
-
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
What kind of developer chooses documentation over development?
-
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...
-
The clue is in the filename .xls. I've encountered this usage innumerable times, at various clients - I'm actually surprised its new to you. I have a vague memory it may even have been in the icon at some stage (just checked it still is - the X with one foot extended to an L).
-
A lot of devs sneer at VBA, but that's mainly because they've never seen just how bluddy useful it can be to people who USE COMPUTERS, rather than spend all their computer-time writing code or playing games. Mind you, finding a dev who can edit a document in a word-processor without screwing the settings/structure/formats up is like finding gold in your bathroom, so finding one who has had experience in making documents even more useful/functional through judicious use of VBA won't be so easy. That said, any dev who says he won't be able to work with VBA, one of the easiest languages to program in, shouldn't be allowed to work with any of the "more difficult" languages until he's proven his mastery of VBA.
I wanna be a eunuchs developer! Pass me a bread knife!
Mark Wallace wrote:
Mind you, finding a dev who can edit a document in a word-processor without screwing the settings/structure/formats up is like finding gold in your bathroom
The same is true of 99% of users who try to apply any formatting to their documents. The difference is that if you point a competent dev to the styles gallery/editor and explain that to avoid screwing the document up that they should use styles similarly to how they use basic CSS instead of font tags then they'll be able to do fancy without trouble in the future. Try doing that with an MBA or someone holding a program managment certificate. :doh:
3x12=36 2x12=24 1x12=12 0x12=18
-
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.
Stefan63 wrote:
knowing that most of today's C++ programs could be compiled with compilers written 20 years ago
Wow, your usage of C++ must really be avoiding the "new" features then. Template support back then was crappy to put it mildly - and IMHO to ignore templates is to miss the one really good thing in C++. Forget the "class" in C++, its the keyword "template" that makes it powerful. There is other stuff that's changed in that time, but the template differences have affected almost every part of the standard library for the better - strings have been vastly improved, STL and BOOST all rely heavily on these. Even books like "Modern C++ Design" by Andrei Alexandrescu came out in that time frame.
-
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.
Hello, this is the business. We have a user who needs to automate a few things in excel. You can either spend 3 months writing custom code that duplicates 20% of the functionality of spreadsheet software plus this user requirement, or spend a day writing a few quick routines in VBA. ... oh... you don't huh. That's too bad.
-
As an accountant, XL is the base level, so therefore I need people who know it. I am an XL guru, not just macros, but vba too. I only employ people who are at least macro level.
------------------------------------ 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[^]
LOL nobody says XL for Excel.