|
Private Sub CommandButton5_Click()
Sheets("Sheet1").Activate
Dim biaoming1, biaoming2 As String
biaoming1 = chengshi & "-异常盒子返厂登记-"
biaoming2 = biaoming1 & Date
If Range("a3").Value = "" Then
MsgBox ("当前表格无数据,无法导出!")
GoTo jieshu1
Else
Dim wb As Workbook
Set wb = Workbooks.Add
ThisWorkbook.ActiveSheet.Copy wb.Sheets(1)
wb.ActiveSheet.Name = "异常登记"
wb.ActiveSheet.Shapes("Button 1").Cut
Application.DisplayAlerts = False
wb.Sheets("sheet1").Delete
wb.SaveAs Filename:=CreateObject("WScript.Shell").SpecialFolders("Desktop") & "\" & biaoming2 & ".xlsx" '报错是这一样代码!
wb.Close
MsgBox ("已导出文件,请前往***桌面***查看标准文件!")
jieshu1:
End If
End Sub
以上的代码,我自己的电脑可以在桌面生成一个以我要求命名的文件,不会报错。但是其他人运行这个表格,只会把表格复制进wb,不会自己存储到桌面,也不会自动命名成指定文件名。
|
|