![8541afeeaceeb16a6d611e6b5e22bfe3.png](https://i-blog.csdnimg.cn/blog_migrate/b09b4e75b9a7be744b2510a8cfaffcaf.jpeg)
需要提取下图文件夹中,所有XLSX格式的文件名称。
![e7230ecfeb2db83b9a62e7a8e9743f82.png](https://i-blog.csdnimg.cn/blog_migrate/100a2ed6e2b24027b1db45c80e23f596.jpeg)
可以通过如下一段VBA代码实现:
----------------------------------------------------------------------------------------------
Sub 提取文件名()
Dim i, j As Integer
Dim mypath, myworkbook
mypath = ThisWorkbook.Path
myworkbook = Dir(mypath & "" & "*.xlsx", vbNormal)
ThisWorkbook.Sheets("汇总表").Range("B2:B65536").ClearContents
i = 2
Do While myworkbook <> ""
If myworkbook <> ThisWorkbook.Name Then
ThisWorkbook.Sheets("汇总表").Cells(i, 2) = myworkbook
End If
myworkbook = Dir
i = i + 1
Loop
End Sub
-----------------------------------------------------------------------------------------------
整个过程如下:
知乎视频www.zhihu.com