View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
asmenut asmenut is offline
external usenet poster
 
Posts: 59
Default Sheet copy after

What if the user just wants to add 1 sheet of the 5?

"Ron de Bruin" wrote:

Hi

You can add sheet templates like this
Sheets.Add Type:=Application.TemplatesPath & "\xxxxx.xlt"

--
Regards Ron de Bruin
http://www.rondebruin.nl



"asmenut" wrote in message
...
Thanks for the help earlier.

Now the problem is that I need to add the sheet(s) from an existing
template
(5 sheets avaiable) without having to open it. Any help would be greatly
appreciated.

Regards