Dim xlApp As New Excel.Application
Dim xlBook As Excel.Workbook
Dim xlSheet As Excel.Worksheet
Dim strTemplateFile As String
Dim strTempFile As String
strTemplateFile = App.Path & "\sysdata\Template.xls"
strTempFile = App.Path & "\sysdata\Temp.xls"
FileCopy strTemplateFile, strTempFile
Set xlApp = CreateObject("Excel.Application")
Set xlBook = xlApp.Workbooks.Open(strTempFile)
' xlBook.Sheets.Delete
Set xlSheet = xlBook.Worksheets.Add
Dim iColHeader As Integer '列头的起始位置
Dim iRowBegin As Integer '数据行的起始位置
Dim xlApp As New Excel.Application
Dim xlBook As Excel.Workbook
Dim xlSheet As Excel.Worksheet
Dim strTemplateFile As String
Dim strTempFile As String
strTemplateFile = App.Path & "\sysdata\Template.xls"
strTempFile = App.Path & "\sysdata\Temp.xls"
FileCopy strTemplateFile, strTempFile
Set xlApp = CreateObject("Excel.Application")
Set xlBook = xlApp.Workbooks.Open(strTempFile)
' xlBook.Sheets.Delete
Set xlSheet = xlBook.Worksheets.Add