"Password to Open" workbook : automation

I have several workbooks that are password protected - meaning I have to enter a password just to open them. The password is simple, "abc".

I get frustrated with opening spreadsheets then having to divert myself to the keyboard to type. Is there any way of automating this process within Excel? For example... I'd like to put some sort of code in my personal.xlsb, that runs every time I open a new workbook... it would essentially check if there is a 'Password to Open' situation, then it would attempt to enter the password "abc". Of course, if I ever opened a file with a different password, this code would simply fail - no big deal.

That's my theory. But I have no idea how to put it into practice - and I've been trying for a very long time.

Any help greatly appreciated. Thank you