Solved: Moving a worksheet

[Tezzies]

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]

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]

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]

Do what I gave you earlier with the macro recorder on.

[Tezzies]

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]

How do i mark this thread as closed

[Bob Phillips]

If you go to Thread Tools at the head of the postings, there should be an option there.