实时错误‘1004’对象‘sheets‘的方法‘global'失败
ezyw 2001-12-05 03:49:34 Private Sub CreateExcelBok()
Dim strSheet As String
Set bokExcel = appExcel.Workbooks.Add
For i = 2 To 8
Sheets.Add
Set shtExcel = bokExcel.Worksheets("Sheet" & CStr(i - 1))
With shtExcel.PageSetup
.BlackAndWhite = False
......
.Zoom = 100
End With
Sheets("Sheet" & CStr(i - 1)).Name = "模" & CStr(i - 1)
Next
Sheets("Sheet8").Name = "汇总"
End Sub
程序运行到Sheets.Add时提示::
实时错误‘1004’对象‘sheets‘的方法‘global'失败
该如何解决???
谢谢!!!