looping wordlist keeps repeating when word not found

[OTH]

Hi,

I have a excel password recovery tool that I have built and it keeps looping through the same wordlist even though it has not been found, what am I missing?

    for x in range(1, len(a)):
        if flag == 1:
            for y in tqdm(permutations(a, x),total=n_words, unit=" words"):
                mypass = ''.join(y)
                passwords_tried = passwords_tried + 1
                try:
                        wb = myfile.Workbooks.Open(xlfile, False, True, None, mypass)
                        # Method: Workbooks.Open(Filename, UpdateLine, ReadOnly, Format, password)
                        wb.Close()
                        flag = flag + 1
                        break

                except:
                        pass
                        print("Incorrect password")
                    
    print("[+] Password Found in "+ str(passwords_tried) + " attempts, Password is " + str(mypass))

if __name__ == '__main__':
        try:
            xlkraken()
        except FileNotFoundError:
            print(Fore.RED,'\n[*] xlkraken interrupted: File path not entered or does not exist!!!')
        except KeyboardInterrupt:
            print(Fore.RED,'\n[*] xlkraken interrupted by user!!!')
        pass
            
print(Fore.BLUE)        
input('Press Enter to Exit')

[nilamo]

You have two for loops, but only break out of one of them. If the intention is to break out of more than one, then either multiple breaks are needed, or just put it in a function and use return instead.

def find_password(myfile, xlfile, a, n_words):
    passwords_tried = 0
    for x in range(1, len(a)):
        for y in tqdm(permutations(a, x),total=n_words, unit=" words"):
            mypass = ''.join(y)
            passwords_tried = passwords_tried + 1
            try:
                wb = myfile.Workbooks.Open(xlfile, False, True, None, mypass)
                # Method: Workbooks.Open(Filename, UpdateLine, ReadOnly, Format, password)
                wb.Close()
                return mypass
             except:
                print("Incorrect password")
    return None # or "" if you prefer