Change password of group of excel files in a folder

[nagovind]

Dear All,
There are many excel files in a folder - folder path is known
Passwords of all excel files are same
Password is known
How to change the passwords with new password to of all excel files in that exists in a particular folder
Please advise the excel macro that works for .xls and and .xlsm

Regards
Govind

 

[nagovind]

Sorry
excel files are inside the sub folders as well