Dim SourceFile, DestinationFile As String, strFile As StringstrFile = Dir("D:\AAA\*.txt") Do Until strFile = "" SourceFile = "D:\AAA\" & strFile DestinationFile = "D:\BBB\" & strFile FileCopy SourceFile, DestinationFile strFile = Dir() Loop 或Dim strFile As StringstrFile = Dir("D:\AAA\*.txt") Do Until strFile = "" Name "D:\AAA\" & strFile As "D:\BBB\" & strFile strFile = Dir() Loop
Shell "copy /y d:\aaa\*.txt d:\bbb",vbHide
楼主的问题直接复制文件夹也可以啊,何必一个个复制呢? Set Fso = CreateObject("Scripting.FileSystemObject") 或者引用 Microsoft Scripting Runtime 然后Dim Fso as New FileSystemObject Fso.CopyFolder "D:\aaa","D:\bbb",[True or False]
fso.copy……2,不支持 *.txt这种通配符。
Dim SourceFile, DestinationFile As String, strFile As StringstrFile = Dir("D:\AAA\*.txt")
Do Until strFile = ""
SourceFile = "D:\AAA\" & strFile
DestinationFile = "D:\BBB\" & strFile
FileCopy SourceFile, DestinationFile
strFile = Dir()
Loop
或Dim strFile As StringstrFile = Dir("D:\AAA\*.txt")
Do Until strFile = ""
Name "D:\AAA\" & strFile As "D:\BBB\" & strFile
strFile = Dir()
Loop
Set Fso = CreateObject("Scripting.FileSystemObject")
或者引用 Microsoft Scripting Runtime 然后Dim Fso as New FileSystemObject
Fso.CopyFolder "D:\aaa","D:\bbb",[True or False]