如果Excel密码忘了,而且是6位数以内的纯数字,可以试试这个方法(记得先关掉其他程序,跑起来快点):
新建一个Excel文件,按下Alt+F11,进VBA界面,点击菜单插入→模块,然后在弹出的窗口里粘贴下面这段代码:
vba
Sub crack()
Dim i As Long
Dim FileName As String
i = 0
FileName = Application.GetOpenFilename(Excel文件(*.xls & *.xlsx),*.xls;*.xlsx, , VBA破解)
FileName = Right(FileName, Len(FileName) - InStrRev(FileName, ))
Application.ScreenUpdating = False
line2: On Error GoTo line1
Workbooks.Open FileName, , True, , i
MsgBox 密码是 & i
Exit Sub
line1: i = i + 1
Resume line2
Application.ScreenUpdating = True
End Sub
粘完后直接按F5运行宏,选你要破解的Excel文件,然后就等吧~看运气和密码长度,耐心等一会儿就能出来。
新建一个Excel文件,按下Alt+F11,进VBA界面,点击菜单插入→模块,然后在弹出的窗口里粘贴下面这段代码:
vba
Sub crack()
Dim i As Long
Dim FileName As String
i = 0
FileName = Application.GetOpenFilename(Excel文件(*.xls & *.xlsx),*.xls;*.xlsx, , VBA破解)
FileName = Right(FileName, Len(FileName) - InStrRev(FileName, ))
Application.ScreenUpdating = False
line2: On Error GoTo line1
Workbooks.Open FileName, , True, , i
MsgBox 密码是 & i
Exit Sub
line1: i = i + 1
Resume line2
Application.ScreenUpdating = True
End Sub
粘完后直接按F5运行宏,选你要破解的Excel文件,然后就等吧~看运气和密码长度,耐心等一会儿就能出来。
