Apply same template to other sheet

S

shampabera

Hi
Following is a code piece:
Dim xlApp As New Excel.Application

Dim xlWB As Excel.Workbook
Set xlWB = xlApp.Workbooks.Add("C:\...\Applicatio
Data\Microsoft\Templates\UBSTplt1.xlt")

Dim xls As Excel.Worksheet
Set xls = xlWB.Worksheets.Add()
xls.Name = "New Sheet"

xlWB.SaveAs ("c:\Test.xls")

My XLT has some predefined header text and colored cells. I want t
apply the same template to the new sheet I am adding to the Workbook a
above.
Can somebody please suggest how?
Thank
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top