vI = 2 Do While vI<= 20 Set xlsheet = xlbook.Worksheets(vI) xlsheet.delete vI = vI + 1 Loop 为什么当第二次执行Set xlsheet = xlbook.Worksheets(vI) 时就出错?(我要实现的功能就是用程序自动删除多余的sheet)
Do While vI<= 20
Application.DisplayAlerts = False '去除删除提示警告
workbooks("workBookName").sheets(startNum).delete
vI = vI + 1
Loop
Application.DisplayAlerts = True