How can i retrieve a worksheet from another workbook using VBA

[CWay]

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

 

[Francis]

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

 

[Gord Dibben]

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


Gord Dibben MS Excel MVP