View Full Version : Solved: Moving a worksheet
Tezzies
12-04-2007, 04:25 AM
Another problem from the vba muppet
I have 2 workbooks-
1. - a.xls stored in c:\test, it has one worksheetsheet called "x"
2. - b.xls stored in c:\destination, it has one worksheet call "y"
how do I move the "x" worksheet into b.xls .
My end product would be - b.xls which contains two worksheets "x" and "y"
Many thanks
Bob Phillips
12-04-2007, 05:07 AM
Select a.xls and make it smaller than b.xls so that you can seel b.xls extending underneath a.xls.
then select the x worksheet, and drag and drop it onto the b.xls tabs where you want to insert it.
Tezzies
12-04-2007, 05:12 AM
thanks for the quick reply , but I was hoping for the vba code.
Along the lines of worksheet.copy ("c:\test\a.xls"), ("C:\destination\b.xls")
Bob Phillips
12-04-2007, 05:39 AM
Do what I gave you earlier with the macro recorder on.
Tezzies
12-04-2007, 09:49 AM
Many thanks. Great tip for discovering new code that. I am fairly new to all this so having the ability to create your own code from the macro is fantastic.
Many thanks again
Tezzies
12-04-2007, 09:52 AM
How do i mark this thread as closed
Bob Phillips
12-04-2007, 11:08 AM
If you go to Thread Tools at the head of the postings, there should be an option there.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.