Hi,

I am currently creating new sheet using the following code:

Private Sub cmdNewSheet_Click()
Sheets.Add Before:=Sheets("Finish"), Type:="C:\Documents and
Settings\Administrator\My Documents\Stock Control\StockTemplate1.xlt"
Sheets(Sheets.Count - 1).Name = txtNewSheet.Text
txtNewSheet.Text = ""
End Sub

What i would like to do is manipulate the code to create the sheet, but
instead of using the file 'Template1.xlt', i would like it to create them
from a worksheet called Temp.

Does anyone have any ideas? Is it even possible?

Thank you in anticipation.

Just copy the sheet.

worksheets("Temp").copy _
before:=worksheets(1)

And move it/rename it to what you want.

That Temp worksheet is in the same workbook, right?

David Coyle wrote:
>
> Hi,
>
> I am currently creating new sheet using the following code:
>
> Private Sub cmdNewSheet_Click()
> Sheets.Add Before:=Sheets("Finish"), Type:="C:\Documents and
> Settings\Administrator\My Documents\Stock Control\StockTemplate1.xlt"
> Sheets(Sheets.Count - 1).Name = txtNewSheet.Text
> txtNewSheet.Text = ""
> End Sub
>
> What i would like to do is manipulate the code to create the sheet, but
> instead of using the file 'Template1.xlt', i would like it to create them
> from a worksheet called Temp.
>
> Does anyone have any ideas? Is it even possible?
>
> Thank you in anticipation.

--

Dave Peterson