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

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

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")