Sub Ma()
'粘贴文件目录所在的地址
mypath = "\\sf\dfssf\SAIFEI\Engineering\02 - Realization\02-04 DES - Develop & Design\02-04-02-Integration\WP3\07_Production_Original PH\AC107 STEP_40\"
myfile = Dir(mypath, vbDirectory)
a = 1
Do While myfile <> ""
If myfile <> "." And myfile <> ".." Then
Cells(a, 1) = myfile
a = a + 1
myfile = Dir
Else
myfile = Dir
End If
Loop
End Sub
07-20
9946
06-24
6189