I generally like helping people but when: students ask for their work to be done with no effort on their part o;r maintaining the solution to a business question is clearly beyond the capabilities of the OP, I tend to want to finish up and tell them that I think it is inappropriate or dangerous to help them more.
If you do this how do you handle it?
Hope this was useful or entertaining.
I send them a PM. I won't show people how to do something in VBA when they can't write a simple formula, or help provide a solution when their data is so badly organized that any attempt is a hack to accommodate their design. In both cases, I feel that doing what they asked does more to hinder their progress than advance it.
Last edited by shg; 03-18-2010 at 10:20 PM.
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
I won't provide solutions to homework, etc-maybe a point in the right direction.
I won't provide VBA solutions where it is not necessary,just asked for because the OP's knowledge of basic Excel usage is lacking.
Also,like Shg if a workbook is badly designed then & the OP won't change it,then I lose interest.
Last edited by royUK; 03-19-2010 at 03:53 PM.
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel consulting, free examples and tutorials visit Excel Consulting-Excel VBA
Check out the free Excel Toolbar
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
Code Tags: Make your code easier for us to read
Roy is absolutely right ...
I would add that the way a question is phrased gives a clear indication of the kind of efforts the OP has already injected in trying to solve his problem ...
What has he done so far, is there an attached file, etc ..
Whenever I sense there is no effort ...no interest ... no perseverance ... I just skip the post ...
Cheers
I often like to make some response to the messy ones. Just to help them understand why they are unlikely to get a reply and I often do that as a PM.
With some of the threads I ask for a bit of information about the business. If it is something where they should and could pay for the work or training I might say so (as a PM (usually)) but if it looks like a small business just trying to make things a bit better I will go the extra mile.
Just occaisionally I am quite pointed in my reply but conscious that others may take a different view.
.
Hope this was useful or entertaining.
Roy's hit the nail on the head pretty much.
One of the most frustrating things I come across is someone insisting that they cannot possibly change the way they have decided they want to do something.
I'm afraid I can be guilty of just drifting away from those threads sometimes.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
If you haven't already please take some time to read the Forum Rules.
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
I've tried so many times to tell OPs that they can do things more simple & offered to help,but why you should we spend more time because they won't see the sense. Most say the "boss" won't allow change, I have never had an employer that when shown a better way to use Excel who wasn't delighted.
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel consulting, free examples and tutorials visit Excel Consulting-Excel VBA
Check out the free Excel Toolbar
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
Code Tags: Make your code easier for us to read
Yes, but that requires confidence that the changes will be better.
I have only had one job where the client said "make it work but don't really change it". I eplained that if they wanted the job to actually work it needed a wholesale restructuring. When they didn't agree I politely suggested that we part then and there.
That caused them some surprise.![]()
Hope this was useful or entertaining.
It also helps to keep a list, either mentally or written down, of OPs who have wasted your time or been rude before. There are a handful of people here that, whenever they post even a simple question, I'm probably going to avoid it because either: A. They posted about 1/10th of their problem and it would go back and forth for over a week, or B. They're just looking for me to do all their work.
As a newbie to the forum I had thought of asking the same question.
My opinion so far
The second "client" appears, drop it!
"the big guys out there"....... etc, etc..... ditto!
Taking all points into consideration......but for the greater God than yours' or mine out there........go thee and I,
How do I do it politely?
Last edited by Marcol; 03-19-2010 at 07:47 PM.
i just take the ****!
Mojito connoisseur and a dabbler in Cisco
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
If you haven't already please take some time to read the Forum Rules.
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
The Holder of the List is amenable to a beer or two...
I'm not sure I've ever seen you post a question though!![]()
So long, and thanks for all the fish.
Luckily it doesn't happen very often
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
If you haven't already please take some time to read the Forum Rules.
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks