Hi
I tried searching online and tried various code but couldn't get one to work in my case.
I have an open workbook (A) and this is where the code should reside. I want to use VBA to copy the content of an entire worksheet from a closed workbook (B) to an existing worksheet in workbook A. How would you accomplish this?
Thank you!
Try this
It will import all the sheet from closed workbook (B)
Please Login or Register to view this content.
Keep the Forum clean :
1. Use [ code ] code tags [ /code ]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
2. Show appreciation to those who have helped you by clicking * Add Reputation below their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
Thanks! What if I just want to copy one sheet from the closed workbook to replace content on an existing sheet of ThisWorkbook?
Last edited by glennchung; 08-21-2014 at 07:05 PM.
Try this one.. Make changes to code with your sheet name..Please Login or Register to view this content.
I made changes to all the sheet names but it stopped after opening the file. The file just stayed open and it didn't go through the copy process. Any idea?
Did you change the sheet names?
Please Login or Register to view this content.
Yes, I did. I copy the raw code again and changed the sheet names and it is still doing the same thing. The selected file is open but nothing was copied to the file with code.
Please Login or Register to view this content.
It looks like it works with this:
Please Login or Register to view this content.
Did you add the sub function part?
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