4

I can't see how this question and the accepted answer will help any future visitors. The tags are wrong, the question is poor, and the answer is in C# while the OP asked for a VBA solution. The provided link will not translate the code into VBA. I flagged it but its been declined. And on top of that VBA != VB.NET. The answer has been accepted but it does not solve the problem.

Is there anything we are going to do about it or not?
case: yes - no further explanation needed
case: no - please explain to why

marked as duplicate by Martijn Pieters, hims056, Cody Gray, Tobias Kienzler, gnat Jul 19 '13 at 14:24

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

  • 1
    How is the question tagged wrong? – Cody Gray Jul 19 '13 at 10:44
  • if you are accepting an answer in C# then vba is not an appropriate tag, specifically when you are asking for a VBA code – user221081 Jul 19 '13 at 10:48
  • @mehow please see the link posted above this comment, I understand exactly where you're at.. have a read of the comments etc, you'll find it helpful, I think – Yvette Colomb Jul 19 '13 at 10:51
  • 1
    Tags have to do with the question, not the answers. He could have accepted an answer that said he should use jQuery. That would have been a bad answer, but it wouldn't affect the question or what tags are appropriate. – Cody Gray Jul 19 '13 at 11:06
  • @CodyGray yes, i guess you are right about that – user221081 Jul 19 '13 at 11:15
  • 1
    xkcd.com/386 – hims056 Jul 19 '13 at 11:15
  • hahaha excellent – user221081 Jul 19 '13 at 11:17
  • The Excel object model isn't fundamentally different, the translation is largely mechanical. If you are a VBA or VB.NET programmer, surviving on C# code samples is a pretty essential survival skill these days. If you don't have that skill then there isn't much point in blaming the guy that posted the answer. – Uphill Luge Jul 19 '13 at 16:36
8

Downvote downvote and downvote. If you think the answer is wrong and will not help any future visitors, then downvote the post!

And please don't flag posts as wrong. You can comment on that answer to get explanation for his answer.

  • I have commented but all the comments have been removed! i have proved the answerer that he is wrong and the translated VB.NET code will not work in VBE. All comments have been removed so what else can I do while I only have 1 downvote. – user221081 Jul 19 '13 at 10:46
  • 4
    Downvoting is good. But so is editing. Don't forget about that! – Cody Gray Jul 19 '13 at 10:46
  • 5
    can't edit to change the meaning of the post Cody – Yvette Colomb Jul 19 '13 at 10:46
  • 2
    @CodyGray - Yes but we can't/shouldn't edit the post to make it correct. – hims056 Jul 19 '13 at 10:47
  • 1
    @hims056 agree meta.stackexchange.com/questions/189407/… – Yvette Colomb Jul 19 '13 at 10:50
  • Ok as simple as downvoting and forgetting about it. I would hate to see SO becoming a W3Schools with tons of misleading supposedly educational information. thanks for your answer hims – user221081 Jul 19 '13 at 10:59
  • @mehow - Also, the meaning of downvote means it is not useful/misleading. – hims056 Jul 19 '13 at 11:01
  • @hims056 yes i agree, however most of the people who come to SO from a search engine result page will most likely ignore the fact that an answers been downvoted since it's accepted and waste their time evaluating it. It may decrease SO reputation in a long run but im not the one to judge or predict. – user221081 Jul 19 '13 at 11:03
  • 1
    No, you don't have to change the meaning. His argument here is that "the question is poor". Poor questions can be fixed. And there is absolutely nothing wrong with translating C# code to VB.NET (if that would help in this case, which it won't). – Cody Gray Jul 19 '13 at 11:07
  • @CodyGray - Oh I misunderstood you. I was talking about answer. I totally agree with you. – hims056 Jul 19 '13 at 11:10
  • 2
    @mehow answers at -3 and below fade to gray. Also, I always look at the score (and maybe even votes) when judging the quality of an answer I found. – John Dvorak Jul 19 '13 at 11:23