Mumps Professional

  • Member since Jul 26th 2011
  • Last Activity:
Posts
1,970
Likes Received
80
Points
6,070
Trophies
1
Profile Hits
831
  • Hi Mumps It's me again, I am asking for some help in the Macro you help me some days ago, I wrote a thread call "Compare cells in a Macro", if you can help me I appreciate it.

  • Mumps. My macro is making my brain melt, and I just know you're my savior to help me understand what my problem is. This is the second website I've made an account on today to try to follow your VBA logic but alas, I'm still struggling. If you could help out, I'd be ecstatic:

    I have spent 10 hours trying and trying my hand at this code. It seems like a repetitive question after scouring the web yet any code I came across gave me some kind of issue, even with hours of tinkering. That being said - SOS


    >I have hundreds of workbooks in a folder on my X drive
    >They all only have one worksheet, titled "Incident Report"
    >They have a various number of lines, all typically maxing out at line 10,027.
    >Each workbooks' data starts at line A28.
    >Each column has data to column AA (last column with data. Column AB and onwards is empty)

    I just want to copy all of this data into my original open sheet (Sheet1) without any line gaps in the data.

    As an aside, these files all downloaded as as an Excel HTTP Page? So every time you try to open one of the files, you get the error that I have attached below. But if you click "Yes", it opens as expected. Is that an underlying issue?

    • Please start a new thread explaining in detail what you want to do. Attach a copy of the file where you want to paste the data and a copy of at least one of the "downloaded" files. Also, include the full path to the folder containing the files from which you want to copy data. When you have done this, send me a private message with a link to your thread and I will be happy to have a look at it.

    • I forgot to mention that most forums have a rule about cross-posting on multiple sites. If you have posted on more than one site, you must include a link to all the other threads on every posting.

  • Hi Mumps, I wrote to you in my post Run a Macro inside another Macro, I am asking for some help

  • Hi Mumps, I hope you are doing well.


    I am having an issue with excel2016, I worked with VBA fine yesterday. Now today, I am unable to view the VBA window. It opens but stays behind , I am unable to edit. This happens for all workbooks I have with codes. Can you say what the issue may be and how I can easily solve it?

    • Without seeing your workbook it's hard to say why that is happening. Could I suggest that you start a new thread describing the problem and post a copy of the file.