Question

关于VBA的，能不能用宏创建一个EXCEL工作表，跪求源代码...

Answer 1

关于VBA的，能不能用宏创建一个EXCEL工作表，跪求源代码...
b 业绩汇总()
Dim wkb As Workbook
Dim sht As Worksheet
Dim d As Integer
Set wkb = Workbooks.Add
d = Day(Now)
For i = 1 To d
Set sht = wkb.Sheets.Add(Before:=Sheets(i))
sht.Name = i
Next i
wkb.SaveAs ThisWorkbook.Path & "\业绩汇总.xls"
End Sub

Answer 2

新建工作表
Sheets.Add '在前面增加一工作表
或
Sheets.Add Before:=Sheets(工作表名称或工作表序号)
Sheets.Add Before:=Sheets("ttt")
Sheets.Add Before:=Sheets(3)

Answer 3

Set wkb = Workbooks.Add