Copy sheet from closed workbook

[dave.cuthill]

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.

 

[ryguy7272]

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

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


HTH,
Ryan--

 

[dave.cuthill]

thanks that was helpful

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''..





- Show quoted text -