|
楼主 |
发表于 2016-10-24 11:41
|
显示全部楼层
Sub Click()
Dim A, wb, p$, temp$, i%
Application.DisplayAlerts = False
A = Sheets("打开数据").[a1].CurrentRegion
p = ThisWorkbook.Path & "\"
For i = 1 To UBound(A)
temp = p & "\需打开文件文件夹\" & A(i, 1) & ".xlsx"
If Dir(temp) <> "" Then
Set wb = Workbooks.Open(temp)
Cells(1, 1) = "姓名"
wb.Close
End If
Application.OnTime Now + TimeValue("00:00:05"), "TIMER"
Next i
Application.DisplayAlerts = True
End Sub
为什么我加了延迟代码后,最后打开了几个文件,就要确定几次上面图片,有办法解决吗?谢谢!
|
|