我做的图书馆里系统,数据备份的时候,只能保存在默认的一个文件夹下,我想让它弹出一个对话框保存在任意目录下,请高手给我改一下
Dim olddb As String
Dim Fs As FileSystemObject
Dim BackUpFile As String
olddb = App.Path + "\" + DBName
BackUpFile = App.Path + "\数据库备份\" + "_" + DBName
If MsgBox("你确定要备份当前数据库吗?", vbQuestion + vbOKCancel _
+ vbDefaultButton2, "请确认") = vbCancel Then
Exit Sub
End If
Set Fs = CreateObject("Scripting.FileSystemObject")
'拷贝数据库文件至指定位置
Fs.CopyFile olddb, BackUpFile
MsgBox "数据库备份成功", vbInformation + vbOKOnly, "信息"
Dim olddb As String
Dim Fs As FileSystemObject
Dim BackUpFile As String
olddb = App.Path + "\" + DBName
BackUpFile = App.Path + "\数据库备份\" + "_" + DBName
If MsgBox("你确定要备份当前数据库吗?", vbQuestion + vbOKCancel _
+ vbDefaultButton2, "请确认") = vbCancel Then
Exit Sub
End If
Set Fs = CreateObject("Scripting.FileSystemObject")
'拷贝数据库文件至指定位置
Fs.CopyFile olddb, BackUpFile
MsgBox "数据库备份成功", vbInformation + vbOKOnly, "信息"
解决方案 »
- 怎样实现插入EXCEL工作表中的图片自动更新,而且更新的图片能指定一个宏?
- 急急急,关于窗体的两个问题,在线等,请知道下菜鸟,解决立刻给分
- #Grid2.0没注册码,帮忙给个
- 哪里有SendMessage,或postmessage的详细介绍啊,最主要的是关于鼠标常量的值啊
- 用winsock同时传送几个文件的时候,为什么有时传了一个文件或者两个文件后就会停止??有什么解决方法吗??
- 软件汉化是怎样实现的?
- 如何写下面的sql语句
- 关于 MTS 中 GetObjectContext 的问题
- 2个按钮,求翻月代码
- 如何把XXXX秒转化成XX:XX:XX的格式
- 汉字转化为拼音
- 如何防止应用程序访问远程数据库是出现掉线的情况!
hWndOwner As Long
pIDLRoot As Long
pszDisplayName As Long
lpszTitle As Long
ulFlags As Long
lpfnCallback As Long
lParam As Long
iImage As Long
End Type
Const BIF_RETURNONLYFSDIRS = 1
Const MAX_PATH = 260
Private Declare Sub CoTaskMemFree Lib "ole32.dll" (ByVal hMem As Long)
Private Declare Function lstrcat Lib "kernel32" Alias "lstrcatA" (ByVal lpString1 As String, ByVal lpString2 As String) As Long
Private Declare Function SHBrowseForFolder Lib "shell32" (lpbi As BrowseInfo) As Long
Private Declare Function SHGetPathFromIDList Lib "shell32" (ByVal pidList As Long, ByVal lpBuffer As String) As LongPrivate Function SelectDirectory(Byval sTitle As String) As String
Dim iNull As Integer, lpIDList As Long, lResult As Long
Dim sPath As String, udtBI As BrowseInfo
With udtBI
.hWndOwner = Me.hWnd
.lpszTitle = lstrcat(sTitle, "")
.ulFlags = BIF_RETURNONLYFSDIRS
End With
lpIDList = SHBrowseForFolder(udtBI)
If lpIDList Then
sPath = String$(MAX_PATH, 0)
SHGetPathFromIDList lpIDList, sPath
CoTaskMemFree lpIDList
iNull = InStr(sPath, vbNullChar)
If iNull Then sPath = Left(sPath, iNull - 1)
End If
SelectDirectory = sPath
End Function
......
Dim olddb As String
Dim Fs As FileSystemObject
Dim BackUpFile As String
Dim sPath As String
sPath = SelectDirectory("请选择数据库备份保存的文件夹")
If sPath <> "" Then
olddb = App.Path + "\" + DBName
BackUpFile = sPath + "数据库备份\" + "_" + DBName
If MsgBox("你确定要备份当前数据库吗?", vbQuestion + vbOKCancel _
+ vbDefaultButton2, "请确认") = vbCancel Then
Exit Sub
End If
Set Fs = CreateObject("Scripting.FileSystemObject")
'拷贝数据库文件至指定位置
Fs.CopyFile olddb, BackUpFile
MsgBox "数据库备份成功", vbInformation + vbOKOnly, "信息"
End If