|
楼主 |
发表于 2024-6-8 14:21
|
显示全部楼层
Option Explicit
Sub test()
Dim ar, i&, r&, strFileName$, strPath$, wks As Worksheet
Application.ScreenUpdating = False
ReDim ar(1 To 10 ^ 4, 2)
strPath = ThisWorkbook.Path & "\"
strFileName = Dir(strPath & "*.xls")
Do Until strFileName = " C:\Users\tqc-00332\Desktop\01\""
With GetObject(strPath & strFileName)
For Each wks In .Worksheets
r = r + 1
ar(r, 0) = strFileName
ar(r, 1) = wks.Name
ar(r, 2) = wks.[Q3].Value
Next
.Close False
End With
strFileName = Dir
Loop
If r Then [A1].Resize(r, 3) = ar
Set wks = Nothing
Application.ScreenUpdating = True
Beep
End Sub
我改了一下路径,运行后表格显示灰色,无内容。 |
|