Private Sub Workbook_Open()
If DateDiff("D", "2016-6-27", Date) > 0 Then
Dim pw
pw = "1234"
ActiveSheet.Unprotect pw
Call 删除代码
ActiveSheet.Protect pw
End If
End Sub
'主程序
Sub test()
Dim p, f
p = ThisWorkbook.Path & "\"
f = "2.xls"
Call myclose(f)
With Workbooks.Open(p & f)
Call DelCode
.Close 1
End With
End Sub
'关闭指定工作簿
Private Sub myclose(f)
On Error Resume Next
Workbooks(f).Close
On Error GoTo 0
End Sub
'删除代码
Private Sub DelCode()
Dim c
For Each c In ActiveWorkbook.VBProject.VBComponents
c.CodeModule.DeleteLines 1, c.CodeModule.CountOfLines
Next
End Sub 新建文件夹.rar(13.98 KB, 下载次数: 7)