View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Sheet copy after

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