|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
如题:
下面有段备份数据的代码
myPath = "c:\0914" mybackupname = InputBox("请输入备份文件名")
上面这两代码能能合并成一个弹窗,手动选择保存路径和指定文件名,实现新增或替换功能。类似二EXCEI另存!
- Sub zidongbaocun()
- Application.ScreenUpdating = False
- Application.DisplayAlerts = False
瑞轩条码转换数据库.rar
(54.71 KB, 下载次数: 0)
- Dim myPath As String
- mybackupname = InputBox("请输入备份文件名")
- If mybackupname = "" Then Exit Sub
- myPath = "c:\0914"
- Sheets(Array("PCB条码", "TRAY盘标签", "PE袋标签", "外箱标签")).copy
- ActiveWorkbook.SaveAs Filename:=myPath & "" & mybackupname & ".xls", FileFormat:=xlNormal _
- , Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _
- CreateBackup:=False
- ActiveWorkbook.Close
- Application.ScreenUpdating = True
- Application.DisplayAlerts = True
- End Sub
复制代码
|
|