Copy a page from an xla file

's Computer Specifications

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

's Computer Specifications

Workbooks("youradd.xla").Sheets(1).Copy _
before:=ActiveWorkbook.Sheets(1)

or

Workbooks("youradd.xla").Sheets("SomeSheetNameHere").Copy _
before:=ActiveWorkbook.Sheets("anothersheetnamehere")

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

's Computer Specifications

Thanks Dave, it works.

Andrew

Dave Peterson wrote:
> Workbooks("youradd.xla").Sheets(1).Copy _
> before:=ActiveWorkbook.Sheets(1)
>
> or
>
> Workbooks("youradd.xla").Sheets("SomeSheetNameHere").Copy _
> before:=ActiveWorkbook.Sheets("anothersheetnamehere")

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I copy a paragraph from web page to excel file?	Convert94	Microsoft Excel New Users	2	16th Sep 2008 04:09 PM
how do i copy page setup settings of an file to every word file?	=?Utf-8?B?Z2FuZXNo?=	Microsoft Word New Users	1	19th Oct 2007 08:13 AM
copy web page to file	Stan	Windows XP General	7	16th Jan 2006 08:28 PM
How to copy web page to word file	Russ	Microsoft Word New Users	1	15th Jan 2004 03:44 AM
How to Copy a File within an ASP.NET-Page	=?ISO-8859-1?Q?Philipp_H=E4nggi?=	Microsoft ASP .NET	3	27th Nov 2003 03:11 PM