I am trying to figure out a way that a sheet can be copied from a
closed workbook into an open workbook. The sheet will have a unique
name which will not be a duplicate to any of the sheets in the
currently open book. I can't seem to find anything on this.

Maybe this:
http://www.rondebruin.nl/ado.htm

Or, this:
http://www.rondebruin.nl/copy7.htm


HTH,
Ryan--

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"(E-Mail Removed)" wrote:

> I am trying to figure out a way that a sheet can be copied from a
> closed workbook into an open workbook. The sheet will have a unique
> name which will not be a duplicate to any of the sheets in the
> currently open book. I can't seem to find anything on this.
>

thanks that was helpful

On Oct 1, 4:43*pm, ryguy7272 <ryguy7...@discussions.microsoft.com>
wrote:
> Maybe this:http://www.rondebruin.nl/ado.htm
>
> Or, this:http://www.rondebruin.nl/copy7.htm
>
> HTH,
> Ryan--
>



> --
> Ryan---
> If this information was helpful, please indicate this by clicking ''Yes''..
>
>
>
> "dave.cuth...@computalog.com" wrote:
> > I am trying to figure out a way that a sheet can be copied from a
> > closed workbook into an open workbook. The sheet will have a unique
> > name which will not be a duplicate to any of the sheets in the
> > currently open book. I can't seem to find anything on this.- Hide quoted text -
>
> - Show quoted text -