供参考 Command1--得到源文件名 Command2--得到目标文件名,并保存 Option Explicit Dim strFilename As String Dim strSavename As String Private Sub Command1_Click() Me.CommonDialog1.ShowOpen strFilename = Me.CommonDialog1.filename End SubPrivate Sub Command2_Click() Dim fso As Object Dim myfile As Object Set fso = CreateObject("Scripting.FileSystemObject") 'Me.CommonDialog1.InitDir = strFilename Me.CommonDialog1.ShowSave strSavename = Me.CommonDialog1.filename Set myfile = fso.getfile(strFilename) myfile.Copy strSavename, True End Sub
filecopy "c:\a.mdb","d:\"
一定要在调用 CommonDialog1.ShowSave 之前使用
CommonDialog1.ShowSave
Command1--得到源文件名
Command2--得到目标文件名,并保存
Option Explicit
Dim strFilename As String
Dim strSavename As String
Private Sub Command1_Click()
Me.CommonDialog1.ShowOpen
strFilename = Me.CommonDialog1.filename
End SubPrivate Sub Command2_Click()
Dim fso As Object
Dim myfile As Object
Set fso = CreateObject("Scripting.FileSystemObject")
'Me.CommonDialog1.InitDir = strFilename
Me.CommonDialog1.ShowSave
strSavename = Me.CommonDialog1.filename
Set myfile = fso.getfile(strFilename)
myfile.Copy strSavename, True
End Sub