I have a folder of different workbooks and I am trying to copy them all into one. I keep getting the error "Method 'Copy' of object'_Worksheet' failed" and I'm not sure how to fix it. This error comes up on the line:
Please Login or Register to view this content.
ThanksPlease Login or Register to view this content.
Hello
Try this code (I have changed the part of ws.Name because if the workbook has more than one sheet, this will cause an error (No two sheets with the same name)
Generally the code is working now for me .. if there are any problems, it is better to upload sample of your workbooks ...
Please Login or Register to view this content.
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
Cross-Post at this link
http://www.vbaexpress.com/forum/show...-into-workbook
It might be wise to read up about cross posting.
See here.
https://www.excelguru.ca/content.php?184
What happens if you change this
to this?Please Login or Register to view this content.
I quickly tried with a folder with workbooks and this works.Please Login or Register to view this content.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks