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
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