Combine/Merge Multiple workbooks/sheets

  • with your latest code I get this message:


    runtime error '-2147021892(80070bbc)':
    Office has detected a problem with this file. To help protect your computer this file cannot be opened.



    When I hit debug,.it goes to this line:


    Workbooks.Open directory & Application.PathSeparator & file.Name

  • Let's go back to my previous approach with the modifications. Try this version.


    If you are still getting the same error message, try opening the file manually to see if it opens without the error.

    You can say "THANK YOU" for help received by clicking the :thumbup: icon in the bottom right corner of the helper's post.
    Practice makes perfect. I am very far from perfect so I'm still practising.

  • I will try in a bit.
    Right now I am opening one file at a time and using ASAP Utilituies to remove all empty rows one sheet at a time. Taking forever.


    I did post another thread asking for some sort of a VBA to remove all Empties in an entire workbook. Waiting for response.


    Thanks,

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!