Excellenceisme
New Member
Hello
I saw this post online at Chandoo VBA forum where they have made macro to add password to all the files in a folder. I will post the macro here again. But I want to change password in the sub folders too and also another criteria is I want to change password of only those fille That starts with name "Performance Report". there are various file starting with same name but for different BU and month
For example : if a folder contains below files, I want to give password all the files that starts with word Performance Report no matter what BU or month they belong. I don't want to do anything to file " Ledger Transaction Report" that exist. Can someone please help me? I am not v good at VBA
Performance Report BU1- Nov
Performance Report BU2 - Nov
Performance Report BU1 - Oct
Ledger Transaction Report
I saw this post online at Chandoo VBA forum where they have made macro to add password to all the files in a folder. I will post the macro here again. But I want to change password in the sub folders too and also another criteria is I want to change password of only those fille That starts with name "Performance Report". there are various file starting with same name but for different BU and month
For example : if a folder contains below files, I want to give password all the files that starts with word Performance Report no matter what BU or month they belong. I don't want to do anything to file " Ledger Transaction Report" that exist. Can someone please help me? I am not v good at VBA
Performance Report BU1- Nov
Performance Report BU2 - Nov
Performance Report BU1 - Oct
Ledger Transaction Report