Change password for multiple Calc files all at the same time?

[Woof4Grrrr]

I created a Calc spreadsheet file years ago to track monthly information. I password-protected this file. I use this file as a template.

Each month, I create a copy of this file and enter info into it for the current month. The copy maintains the password of the original file, of course.

After more than 15 years of this, I have many such files that are all protected by the same password. Now, I would like to change the passwords for all these files, all at once. Is there a way to do this? Some command-line options perhaps?

Thank you for any experience with this that you might care to share.

[Zizi64]

You can write a macro for this task.

A similar topic on the common AOO/LO forum:
https://forum.openoffice.org/en/forum/viewtopic.php?t=105221

And here is an another from this site:

Saving current document with password from macro

Pgp decrypts all of your pgp-encrypted files. One program to encrypt and decrypt your files properly regardless of file types.

[Woof4Grrrr]

Thank you for your reply.

Working with Python is far beyond my depths, but I did try using the script in the article you mentioned, however, and there was an error on the very second line: “import uno”

I found the file “uno.py” in the LibreOffice program install folder, but I don’t know how to tell Python the path to where “uno.py” is located. Apparently you cannot just provide the full path on the import statement

Also, the command line used to to run the script seems to be specific to Linux/Unix. I don’t know what to do with the “&” in the command line. Windows command prompt doesn’t seem to like it

BTW - I am a retired software developer (not Python) using Windows 10.