I have 2 open workbooks (Workbook A and B). I would appreciate a macro that copies the current active sheet (in Workbook A) into Workbook B. The sheet can be placed at the very end of Workbook B.
I have 2 open workbooks (Workbook A and B). I would appreciate a macro that copies the current active sheet (in Workbook A) into Workbook B. The sheet can be placed at the very end of Workbook B.
Last edited by Xx7; 05-18-2012 at 04:37 PM.
Maybe:
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
It works, but I have a question. I will always have only 2 workbooks open in an instance. Therefore, is it possible NOT to define an exact path "C:\Path\To\The\File\Book2.xls". But instead ensure the path is the other open workbook?
If your workbook is open, then the line of code before that will do the job. Just take that line out, it's jus there in case you forget.
If that takes care of your need, please select Thread Tools from menu above and set this topic to SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks