View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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.