| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy a page from an xla file
Hi
When you set the property IsAddin = true for an xla file, any workbook pages become invisible to normal users. Is it possible to easily copy one of those 'invisible' pages to another opened, normal xls file ? This page to copy might be an update for an existing page in the xls file. TIA Andrew |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy a page from an xla file
Workbooks("youradd.xla").Sheets(1).Copy _
befo=ActiveWorkbook.Sheets(1) or Workbooks("youradd.xla").Sheets("SomeSheetNameHere ").Copy _ befo=ActiveWorkbook.Sheets("anothersheetnameher e") Andrew Bourke wrote: Hi When you set the property IsAddin = true for an xla file, any workbook pages become invisible to normal users. Is it possible to easily copy one of those 'invisible' pages to another opened, normal xls file ? This page to copy might be an update for an existing page in the xls file. TIA Andrew -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy a page from an xla file
Thanks Dave, it works.
Andrew Dave Peterson wrote: Workbooks("youradd.xla").Sheets(1).Copy _ befo=ActiveWorkbook.Sheets(1) or Workbooks("youradd.xla").Sheets("SomeSheetNameHere ").Copy _ befo=ActiveWorkbook.Sheets("anothersheetnameher e") |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Saving Excel 2010 files as web page or single file web page | Excel Discussion (Misc queries) | |||
| copy a cell from page 1 to page 2 in excel | Excel Discussion (Misc queries) | |||
| How do I copy a paragraph from web page to excel file? | New Users to Excel | |||
| Copy cell from Excel file and paste into control on internet page | Excel Programming | |||
| Macro that copy page to page just some filled cells | Excel Discussion (Misc queries) | |||
![Andrew Bourke[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
