Sub 列出所有文件名() Dim xlsFile As String xlsFile = Dir(ActiveWorkbook.Path & "\*.XLS") Do If InStr(1, xlsFile, ActiveWorkbook.Name) = 0 Then Cells(([A65536].End(xlUp).Row + 1), 1) = xlsFile End If xlsFile = Dir Loop Until Len(xlsFile) = 0 End Sub *************由剪水同学代码进行小小修改的**************