add a existing worksheet to a workbook

[Scrap]

Here is the way to add a worksheet already existing:

-Save your workbook with the sheet. (File; save as...; In the Save as type Combobox, Choose template(*.xlt) _Be sure to remember the path!_

-Use this code:

Sheets.Add Type:="\\your_path_here\template.xlt"
or

Sheets.Add type:="c:\...\template.xlt"

:thumb

[Jacob Hilderbrand]

Sounds like a good idea for a Kb Entry. Check out our Knowledgebase (http://www.vbaexpress.com/kb) and submit your code if you like.

[Anne Troy]

Cool! Another coder!! Scrap, just like the forum, you only have to log into the KB once, and you use the same login as you have here at the forum. We couldn't get them to synch.