' 還原這個數據庫 Public Function DoRestore(ByVal strSourceFile As String) As Boolean On Error Resume Next Dim lFileOp As Long Dim lResult As Long Dim lFlags As Long Dim SHFileOp As SHFILEOPSTRUCT lFileOp = FO_COPY lFlags = lFlags And Not FOF_SILENT lFlags = lFlags Or FOF_NOCONFIRMATION lFlags = lFlags Or FOF_NOCONFIRMMKDIR lFlags = lFlags Or FOF_FILESONLY
With SHFileOp .wFunc = lFileOp .pFrom = strSourceFile & vbNullChar .pTo = AppPath & "test.mdb" & vbNullChar .fFlags = lFlags End With lResult = SHFileOperation(SHFileOp)
fso.CopyFile "c:\backup\backup.mdb", "c:\old.mdb", True
Public Function DoRestore(ByVal strSourceFile As String) As Boolean
On Error Resume Next
Dim lFileOp As Long
Dim lResult As Long
Dim lFlags As Long
Dim SHFileOp As SHFILEOPSTRUCT
lFileOp = FO_COPY
lFlags = lFlags And Not FOF_SILENT
lFlags = lFlags Or FOF_NOCONFIRMATION
lFlags = lFlags Or FOF_NOCONFIRMMKDIR
lFlags = lFlags Or FOF_FILESONLY
With SHFileOp
.wFunc = lFileOp
.pFrom = strSourceFile & vbNullChar
.pTo = AppPath & "test.mdb" & vbNullChar
.fFlags = lFlags
End With
lResult = SHFileOperation(SHFileOp)
DoRestore = lResult = 0End Function//調用這個function就可以了
fso.CopyFile "c:\backup\backup.mdb", "c:\old.mdb", True
↑ ↑
文件名在copy的过程中被改变了
扩展名当然也可以改的,你可以用copy命令把abc.cba拷贝出一个cba.abc
只要你别让源文件与目标文件既同名又同目录就行了