|
楼主 |
发表于 2020-5-29 16:11
|
显示全部楼层
我自己试着写了个,从基础数据簿按按钮,然后发送到数据汇总簿。但是好像不能实现如果数据汇总簿开着,就保持开着,数据汇总簿关闭的话,就保持关闭。好像都会把数据汇总簿打开,老师能帮我查下代码吗
Sub 行业()
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Set Rng = Range("I306:AY877")
Workbooks.Open Filename:=ThisWorkbook.Path & "\数据汇总.xlsx"
flag = 0
For Each sht In Sheets '检索目标工作表是否在sheets集合
If sht.Name = Format(Now(), "yyyymmdd") Then
flag = 1
Sheets(Format(Now(), "yyyymmdd")).Activate
Range("a1:ay10000").Clear
Range("a1").Resize(Rng.Rows.Count, Rng.Columns.Count).Value = Rng.Value
Exit For
End If
Next
If flag = 0 Then
Sheets.Add(After:=Sheets(2)).Name = Format(Now(), "yyyymmdd")
End If
''''
Sheets(3).Activate
Range("a1").Resize(Rng.Rows.Count, Rng.Columns.Count).Value = Rng.Value
Workbooks(ThisWorkbook.Name).Save
'Application.Quit
End Sub
|
|