While SysTools VBA Password Remover is a reliable solution, there are alternative tools available:
: Run the activated software and browse for the protected file.
: Supports Excel ( .xls , .xlsm , .xlam ), Word ( .doc , .docm ), and Access ( .mdb , .accdb ).
This serves as a "proof of concept." It can scan files to verify that a VBA project exists and may even initiate the recovery, but it will only display the first two characters of the newly generated password.