Dim appXls As Excel.Application
Dim sht As Excel.Worksheet
Set appXls = New Excel.Application
appXls.Workbooks.Add
appXls.Worksheets(1).Name = "Test"
appXls.Visible = True
Set appXls = Nothing
Dim sht As Excel.Worksheet
Set appXls = New Excel.Application
appXls.Workbooks.Add
appXls.Worksheets(1).Name = "Test"
appXls.Visible = True
Set appXls = Nothing
Worksheets(1).Name = "Test"
Worksheets(2).Visible = False '隐藏第2张工作表
Worksheets(3).Visible = False
第二个问题
Dim wObj As Object, dObj As Object
Set wObj = CreateObject("excel.application")
Set dObj = wObj.Workbooks.Add
dObj.SaveAs (App.Path & "\工作计划.xls")
wObj.Quit
Set wObj = Nothing