| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| RETRIEVE DATA FROM ANOTHER WORKBOOK BY CHECKING ON WORKBOOK DATE | Excel Worksheet Functions | |||
| Retrieve text from filter data in workbook 1 and place values in 2 | Excel Discussion (Misc queries) | |||
| how do i retrieve a deleted worksheet | New Users to Excel | |||
| Retrieve Excel Workbook | Excel Worksheet Functions | |||
| How do I retrieve & view multiple matches from another workbook? | Excel Worksheet Functions | |||
Linear Mode
