发布于 2009-08-24 13:59:57
0楼
Dim ExcelApp
Dim ExcelBook
Dim ExcelSheet
Set excelApp = CreateObject("Excel.Application")
Set ExcelBook = excelApp.Workbooks.Open("d:\cc.xls")
excelApp.DisplayAlerts = False
Set Excelsheet = ExcelBook.Worksheets("s1")
ExcelBook.Sheets.Add
ExcelBook.ActiveSheet.name = "ssss127"
ExcelBook.Save
ExcelApp.Workbooks.Close
ExcelApp.Quit
Set ExcelApp = Nothing
非淡泊无以明志,非宁静无以致远