| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy worksheet from xla to xls
Hello:
I would like to copy an existing worksheet, which is hidden in an add-in XLA and copy it to an existing XLS file? Can someone help? I have tried many things, but most of them crash...so I'm stucked. Thanks in advance... Andy |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copy worksheet from xla to xls
This worked ok for me:
Option Explicit Sub testme() Workbooks("personal.xla").Worksheets("sheet1").Cop y _ befo=ActiveWorkbook.Worksheets(1) End Sub Sheet1 wasn't a hidden worksheet in the addin. ndalal wrote: Hello: I would like to copy an existing worksheet, which is hidden in an add-in XLA and copy it to an existing XLS file? Can someone help? I have tried many things, but most of them crash...so I'm stucked. Thanks in advance... Andy -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy Worksheet wont copy objects. | Excel Worksheet Functions | |||
| Unable to Insert Worksheet/Move and copy worksheet Excel 2003 | Excel Worksheet Functions | |||
| copy range on every worksheet (diff names) to a master worksheet (to be created) | Excel Programming | |||
| copy range on every worksheet (diff names) to a master worksheet (to be created) | Excel Programming | |||
| Code to copy range vs Copy Entire Worksheet - can't figure it out | Excel Programming | |||
Linear Mode
