你好 谢谢大神指点
但是为什么我运行这个宏的时候显示错误呢?
Sub 所有()
Dim i As Integer
Dim path As String, pathxx As String
Dim Filename As String
Application.ScreenUpdating = False
twna = ThisWorkbook.Name
pathxx = ThisWorkbook.path
path = ThisWorkbook.path & "\*.CSV"
Filename = Dir(path)
Do
If Filename <> ThisWorkbook.Name Then
i = i + 1
Range("Bx" & i) = Filename
End If
Filename = Dir
Loop Until Filename = ""