Hi,
I received such files every month:
Sales_China.xlsm
Sales_India.xlsm
Sales_Korea.xlsm
All these files are password protected. The password is stored in another file in the following format:
Column A Column B
China jUhI
India ruOp
Korea uEws
The sheets in the file I receive are protected with 'abcd123'. This is the same for all files.
How do i write a macro such that if the file contains values that match Column A in the file with the passwords, unlock the file with the respected password and save the file as .xslx.
The ultimate goal is to save all the file as .xlsx. I receive 50+ such files and so doing it manually is a bit tedious.
Bookmarks