Public batch$
Sub crAddReport()
'获取窗体单选框选择
UserForm1.Show
If UserForm1.OptionButton1.Value = True Then
batch = "一"
ElseIf UserForm1.OptionButton2.Value = True Then
batch = "二"
ElseIf UserForm1.OptionButton3.Value = True Then
batch = "三"
End If
t1 = Timer
Application.ScreenUpdating = False
Call importLog '引用模块2的方法
Call findBrokenStation '引用模块2的方法
Call nowCrReport2
Call crFile2
Application.ScreenUpdating = True
t2 = Timer
MsgBox "己完成,运行时间 = " & (t2 - t1) * 1000 & " ms"
End Sub
Sub crFile2()
Worksheets("结果统计-新增").Copy
With ActiveSheet
.Select
.Columns("A:E").Delete
.Shapes.Range(Array("Picture 1")).Delete
[I1] = "执行结果"
[I2] = "断X"
[I3] = "配齐4个XX"
[I4] = "无XX数据"
[I5] = "因XXXX未配齐"
[I6] = "总计"
[J1] = "数量"
[J2].formula = "=COUNTIF(E:E,I2)"
[J3].formula = "=
【VBA】【一天的心血,收藏一下】一键生成报表2
最新推荐文章于 2025-04-02 15:38:08 发布