VBA中复制文件的步骤

Sub CopyToAbort()
Dim folder As String
Dim source As String
Dim dest As String
Dim msg1 As String
Dim msg2 As String
Dim p As Integer
Dim s As Integer
Dim i As Long
On Error GoTo ErrorHandler
folder = "C:Abort"
msg1 = "The selected file is already in this folder."
msg2 = "was copied to"
p = 1
i = 1
 get the name of the file from the user 从用户处获取文件名称
source = Application.GetOpenFilename
 don’t do anything if cancelled 如果取消则不进行任何操作
If source = "False" Then Exit Sub
 get the total number of backslash characters "" in the source 获取文件来源字符
串中的反斜杠数
 variable’s contents
Do Until p = 0
p = InStr(i, source, "", 1)
If p = 0 Then Exit Do
s = p
i = p + 1
Loop
 create the destination file name 创建目的文件名称
dest = folder & Mid(source, s, Len(source))
 create a new folder with this name 创建同名文件夹
MkDir folder
 check if the specified file already exists in the 检查该文件是否在目的地已经存
在
 destination folder
If Dir(dest) <> "" Then
MsgBox msg1
Else
 copy the selected file to the C:Abort folder 复制所选文件到文件夹“C:Abort”
FileCopy source, dest
MsgBox source & " " & msg2 & " " & dest
End If
Exit Sub
ErrorHandler:
If Err = "75" Then
Resume Next
End If
If Err = "70" Then
MsgBox "You can’t copy an open file."
Exit Sub
End If
End Sub