Set FSO = CreateObject("Scripting.FileSystemObject")
Set FolderArr = FSO.getfolder(gMyPath1)
With FolderArr
If .subfolders.Count <> 0 Then
For Each f1 In .subfolders
For Each fn In f1.Files
n = n + 1
FSO.CopyFile fn.path, gMyPath2 & "\" & n & ".xls"
Next
Next
End If
End With
上面的程序是将gMyPath1目录下所有文件夹中的工作簿拷贝到gMyPath2文件夹中,并以序号命名所有工作簿。