I am going to get batches of 200+ Excel files with a blank password, one just needs to press enter when asked for the password. The system I am loading these files into cannot handle password protected Excel sheets. Is there a command line or other solution where I can just open those Excel sheets with the known blank password and then re-save them without a password?
This password is to open the file.
I followed the recommendation in STTR's answer and used DocRecrypt. I am no longer prompted for a password for these files when opening them. Awesome.