【EXCEL VBA】破解EXCEL VBA巨集 密碼

by zhi hao

1.啟用後點選解密檔案,
2.自動備份原始檔案
3.開啟解密後檔案,彈出視窗按下確定即可進入

 Sub VBAPassword() '你要解保護的Excel文件路徑 FileName = Application.GetOpenFilename("Excel文件(*.xls & *.xla & *.xlsx),*.xls;*.xla;*.xlsx", , "VBA破解") If Dir(FileName) = "" Then MsgBox "沒找到相關文件,請重新設置。" Exit Sub Else FileCopy FileName, FileName & ".bak" '備份文件。 End If Dim GetData As String * 5 Open FileName For Binary As #1 Dim CMGs As Long Dim DPBo As Long For i = 1 To LOF(1) Get #1, i, GetData If GetData = "CMG=""" Then CMGs = i If GetData = "[Host" Then DPBo = i - 2: Exit For Next If CMGs = 0 Then MsgBox "請先對VBA編碼設置一個保護密碼...", 32, "提示" Exit Sub End If Dim St As String * 2 Dim s20 As String * 1 '取得一個0D0A十六進制字串 Get #1, CMGs - 2, St '取得一個20十六制字串 Get #1, DPBo + 16, s20 '替換加密部份機碼 For i = CMGs To DPBo Step 2 Put #1, i, St Next '加入不配對符號 If (DPBo - CMGs) Mod 2 <> 0 Then Put #1, DPBo + 1, s20 End If MsgBox "文件解密成功......", 32, "提示" Close #1 End Sub

相關文章

發表回應

本網站放置cookies,務求為您提供最佳的網上瀏覽體驗。 接受 閱讀更多