要是确定都是数字组成的
可以用vba解决(适合简单的数字密码)
Sub sas()
On Error Resume Next
Dim ms As String
Dim x As Long
Dim mpath As String
ms = Application.GetOpenFilename
Range("D6") = ms
For x = 1 To 300000000
Range("D8") = x
Workbooks.Open Filename:=ms, Password:=x
mpath = ActiveWorkbook.Path & "\" & ActiveWorkbook.Name
If mpath Like ms Then
MsgBox "文件打开"
Exit Sub
End If
Next