|
dsmch 发表于 2010-8-27 08:46
这是我以前一直在用的代码提交出来供大家研究,请先在D盘建一个凭证保存文件夹(存盘和名字可改变)
Sub 凭证另存并删除宏代码()
Dim i As Integer
Dim codeLines As Integer
Dim shtName As String
shtName = "Sheet1"
ThisWorkbook.Worksheets(shtName).Copy
codeLines = ActiveWorkbook.VBProject.VBComponents(shtName).CodeModule.CountOfLines
ActiveWorkbook.VBProject.VBComponents(shtName).CodeModule.DeleteLines 1, codeLines
ActiveWorkbook.SaveAs Filename:="D:\备份\凭证" & Format(Now, "YYYY-MM-DD-HHmmSS") & ".xls", _
FileFormat:=xlNormal, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False
ActiveWorkbook.Close
End Sub
|
|