jolivanes Professional

  • Member since Jul 8th 2004
  • Last Activity:
Posts
1,237
Likes Received
54
Points
3,869
Trophies
1
Profile Hits
2,965
  • A big part of the problem is when you grow up in a caste system. if you are in the top of the four, everybody else that helps is just a minion and why should you even think of responding to THEIR wishes.

    I just hope that I remember his moniker so I can skip his posts.

    I am just dreaming here but it would be nice if all the sites together had a database with names in it to avoid.

    How are things in Germany? That's where you reside now isn't it.

    Good luck and thanks for the update.

    • Yes, most of my time these days is taken up building my castle in the Bavarian Hills.

      Things are all under control here. Hope things are OK by you and yours.

      These are a few of his names that I have dealt with

      zyxw123

      jhas56788

      rider

      roger

      anjus

      Leonardo1234

      Umpsbug

      Kinjals

      Tinamishra

      kinjal124

      sumanjjj

      rider1234

      [email protected]

      andy124

      [email protected]

      fixer

      vixer

      But his posts are fairly easy to recognise, in particular as the questions are so similar. This is something that makes him interesting in a strange way, as he is such an extreme example of a common stereotype poster from India.

      I am less active in the main forums anymore. My Excel hobby was more of something to do in the long beautiful white winters we had before Global warming / Climate change spoilt that.

      I post at a few Blog site comment sections and some of the quieter forums now

      I may buy excelfox next winter. A nice, very quiet forum , that suits me now. The owner kindly made me an Admin to help practice for in the event I buy it. I like the older vBulliten forum format.

      This OP posts a lot there, at least in between the temporary bans I have given him a few times now. At excelfox I could merge almost 40 of his Threads into 8. That helped a little. Merging, if possible, can help a little in such a case.

      Take care.

  • Hi there,


    About the Op here COPY AND PASTE


    This OP is a very , very unique case. I never met anyone like him, and I have a reputation of getting through to the poor communicators better than most.

    He had an original solution, which worked. He missed that, and went on to go around in circles for a few weeks at various duplicated cross posts.


    This is a typical example of how things often go with this OP…..

    He appears to understand or read almost nothing of what is ever posted for him..

    He looks in a reply for a macro. Sometimes he runs it, sometimes he doesn’t, sometimes he copies it wrong.

    If he does not get exactly what he wants, ( what he wants is something which no one can ever know ), he posts some gibberish. Then,

    He looks in a reply for a macro. Sometimes he runs it, sometimes doesn’t, sometimes he copies it wrong.

    If he does not get exactly what he wants, ( which is what no one can ever know ), he posts some gibberish. Then,

    He looks in a reply for a macro. Sometimes he runs it, sometimes doesn’t, sometimes he copies it wrong.

    If he does not get exactly what he wants, ( which is what noone can ever know ), he posts some gibberish. Then,

    …etc.


    Eventually, whether he gets what he wants or not, there comes a canned reply, which may or may not be the last post, of the form ..“Thx for great help. Problem Solved Sir, Have a great day“…


    ( Currently, his main issue is that he cannot understand anything at all about the difference between an Excel File and an Text File and that is causing havoc with multiple cross duplicated posts everywhere. )


    A very unique case. I sometimes wonder if he is real , or if he is some higher being, having been sent to „test“ us…


    Alan


    These are the cross post I have seen so far. There are probably a few more.

    https://excelfox.com/forum/sho…3439&viewfull=1#post13439

    https://chandoo.org/forum/threads/copy-and-paste.44182/

    https://www.experts-exchange.c…h-saving-of-the-file.html

    COPY AND PASTE

    http://www.eileenslounge.com/viewtopic.php?f=30&t=34508

  • Here is an example

    This should copy all 4th Columns From All Workbooks into Master providing that all, incl Workbook with code ("Master"?) are saved in one and the same Folder.

    Change references, like Sheet names, as required.


    Code

    1. Sub Get_Columns()
    2. Dim sPath As String
    3. Dim sFil As String
    4. Dim owb As Workbook
    5. Dim twb As Workbook
    6. With Application
    7. .Calculation = xlCalculationManual
    8. .EnableEvents = False
    9. .ScreenUpdating = False
    10. End With
    11. Set twb = ThisWorkbook
    12. sPath = ThisWorkbook.Path & "\"
    13. sFil = Dir(sPath & "*.xl*")
    14. Do While sFil <> "" And sFil <> twb.Name
    15. Set owb = Workbooks.Open(sPath & sFil)
    16. owb.Sheets("data").Columns(4).Copy twb.Sheets("report").Cells(1, Columns.Count).End(xlToLeft).Offset(, 1) '<----- Change sheet names
    17. owb.Close False 'Close no save
    18. sFil = Dir
    19. Loop
    20. With Application
    21. .Calculation = xlAutomatic
    22. .EnableEvents = True
    23. .ScreenUpdating = True
    24. End With


    ######################################################################

    Hi,

    When I was trying to use this in a folder with excel files named Image001, Image002 ... ect, some how only the last excel file information is getting copied, any help??





    1. End Sub