Public Sub Search_file_in_folder(folder_name As String) '遍历指定文件夹下的所有文本文件
Dim Files() As StringDim a As IntegerFileType = "*.*"sPath = Dir(folder_name & FileType) '查找第一个文件Do While Len(sPath) '循环到没有文件为止a = a + 1ReDim Preserve Files(1 To a)Files(a) = path & sPath '将文件目录和文件名组合,并存放到数组中sPath = Dir '查找下一个文件DoEvents '让出控制权LoopEnd Sub
Dim Files() As StringDim a As IntegerFileType = "*.*"sPath = Dir(folder_name & FileType) '查找第一个文件Do While Len(sPath) '循环到没有文件为止a = a + 1ReDim Preserve Files(1 To a)Files(a) = path & sPath '将文件目录和文件名组合,并存放到数组中sPath = Dir '查找下一个文件DoEvents '让出控制权LoopEnd Sub
调用的时候参数folder_name所对应的字符串一定要以"\"为结尾,比如"c:\";
Files(a) = path & sPath
改成
Files(a) = folder_name & sPath
应该就可以了.