Hello, I have never used this or any forum before, so please bear with me.
I have seen several very similar questions, but am not finding the specific answer I am in need of.
May I ask, what VBA code would you use to open all of the workbooks in one network location that are currently password protected, then save them with a new password?
these files are password protected to open (other than read only) and have at least one sheet, some have multiple.
I am in Excel 2013 so my attempts to use "with Application.filesearch" would not work.
Please advise, and thank you in advance for your time and help.
I have seen several very similar questions, but am not finding the specific answer I am in need of.
May I ask, what VBA code would you use to open all of the workbooks in one network location that are currently password protected, then save them with a new password?
these files are password protected to open (other than read only) and have at least one sheet, some have multiple.
I am in Excel 2013 so my attempts to use "with Application.filesearch" would not work.
Please advise, and thank you in advance for your time and help.