+ Reply to Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 27
  1. #1
    Valued Forum Contributor tony h's Avatar
    Join Date
    03-14-2005
    Location
    England: London and Lincolnshire
    Posts
    768

    when and how do you give up with an OP

    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.

  2. #2
    Forum Moderator shg's Avatar
    Join Date
    06-21-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2007
    Posts
    25,137

    Re: when and how do you give up with an OP

    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

  3. #3
    Forums Administrator royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    24,447

    Re: when and how do you give up with an OP

    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

  4. #4
    Valued Forum Contributor JeanRage's Avatar
    Join Date
    03-02-2009
    Location
    Nice, France
    MS-Off Ver
    Excel 2003
    Posts
    705

    Re: when and how do you give up with an OP

    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

  5. #5
    Valued Forum Contributor tony h's Avatar
    Join Date
    03-14-2005
    Location
    England: London and Lincolnshire
    Posts
    768

    Re: when and how do you give up with an OP

    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.

  6. #6
    Forum Guru Domski's Avatar
    Join Date
    12-14-2009
    Location
    Leeds, UK
    MS-Off Ver
    2003 (work), 2007 & 2010 (home)
    Posts
    3,517

    Re: when and how do you give up with an OP

    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.

  7. #7
    Forums Administrator royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    24,447

    Re: when and how do you give up with an OP

    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

  8. #8
    Valued Forum Contributor tony h's Avatar
    Join Date
    03-14-2005
    Location
    England: London and Lincolnshire
    Posts
    768

    Re: when and how do you give up with an OP

    Quote Originally Posted by royUK View Post
    I have never had an employer that when shown a better way to use Excel who wasn't delighted.
    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.

  9. #9
    Forum Guru darkyam's Avatar
    Join Date
    03-05-2008
    Location
    Colorado, US
    MS-Off Ver
    2007
    Posts
    2,140

    Re: when and how do you give up with an OP

    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.

  10. #10
    Forum Guru Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    5,139

    Re: when and how do you give up with an OP

    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.

  11. #11
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    10,477

    Re: when and how do you give up with an OP

    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

  12. #12
    Forum Moderator romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    Alibi
    MS-Off Ver
    All
    Posts
    8,262

    Re: when and how do you give up with an OP

    Quote Originally Posted by darkyam View Post
    It also helps to keep a list, either mentally or written down, of OPs who have wasted your time or been rude before.
    I've often wondered if it was just me that did that. I have one for each forum I post in - some very short, some not so...
    So long, and thanks for all the fish.

  13. #13
    Forum Guru Domski's Avatar
    Join Date
    12-14-2009
    Location
    Leeds, UK
    MS-Off Ver
    2003 (work), 2007 & 2010 (home)
    Posts
    3,517

    Re: when and how do you give up with an OP

    Quote Originally Posted by romperstomper View Post
    I've often wondered if it was just me that did that. I have one for each forum I post in - some very short, some not so...
    Who do I have to appeal to about getting my name removed from them?

    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.

  14. #14
    Forum Moderator romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    Alibi
    MS-Off Ver
    All
    Posts
    8,262

    Re: when and how do you give up with an OP

    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.

  15. #15
    Forum Guru Domski's Avatar
    Join Date
    12-14-2009
    Location
    Leeds, UK
    MS-Off Ver
    2003 (work), 2007 & 2010 (home)
    Posts
    3,517

    Re: when and how do you give up with an OP

    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.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.2.0