Dim xlsApp As Excel.Application Dim xlsBook As Excel.Workbook Dim xlsSheet1 As Excel.Worksheet, xlsSheet2 As Excel.Worksheet Set xlsApp = CreateObject("Excel.Application") xlsApp.Visible = True xlsApp.DisplayAlerts = False Set xlsBook = xlsApp.Workbooks.Open("d:\111.xls") Set xlsSheet1 = xlsBook.Sheets(2) Set xlsSheet2 = xlsBook.Sheets.Add(xlsSheet1) xlsSheet2.Name = "aaaa" xlsBook.Save
Dim xlsBook As Excel.Workbook
Dim xlsSheet1 As Excel.Worksheet, xlsSheet2 As Excel.Worksheet Set xlsApp = CreateObject("Excel.Application")
xlsApp.Visible = True
xlsApp.DisplayAlerts = False
Set xlsBook = xlsApp.Workbooks.Open("d:\111.xls")
Set xlsSheet1 = xlsBook.Sheets(2)
Set xlsSheet2 = xlsBook.Sheets.Add(xlsSheet1)
xlsSheet2.Name = "aaaa"
xlsBook.Save