Sheet copy after
 

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

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

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

Sheet copy after
 

If you know what sheet to keep, then you could delete the other 4.

If you're concerned that the names of the 5 inserted sheets may have changed,
you could create a new workbook based on that template, delete the 4 sheets you
don't need and then move that remaining sheet into your workbook.

Another alternative (maybe easier) is to just create a workbook with that single
sheet in it. And then use that for your template.

asmenut wrote:

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




--

Dave Peterson