VBA open excel files and add password to them

[devendra.dvm]

Hi Experts,
Im looking for a code that can open excel files in a folder and add passwords to them

i have a excel sheet with files names with path in column A and passwords column B against each file name as mentioned in below image.. i want to open file1 and add password which is mentioned in column B.


Any help greatly appreciated.

thanks in advance.



Cross Post: https://stackoverflow.com/questions/53313685/vba-open-excel-files-and-add-password-to-them