How can i retrieve a worksheet from another workbook using VBA
 

I am trying select a specific worksheet from another open workbook, copy it
as the first tab in the active workbook.

How can i retrieve a worksheet from another workbook using VBA
 

Would a select, copy and paste do the task you want?
Select the sheet you want to copy
Click above row 1, this will highlight the whole sheet
Copy, go to the target workbook and paste on the Sheet1.

--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another



"CWay" wrote:

I am trying select a specific worksheet from another open workbook, copy it
as the first tab in the active workbook.

How can i retrieve a worksheet from another workbook using VBA
 

Turn on the macro recorder and do the steps manually to see the code
generated.


Gord Dibben MS Excel MVP

On Tue, 14 Apr 2009 09:14:07 -0700, CWay
wrote:

I am trying select a specific worksheet from another open workbook, copy it
as the first tab in the active workbook.