Password-protect excel files in folder

Hi,

I'm hoping someone can help. I'm trying to build a quick tool that displays a list of all Excel files from a given folder and then password-protect each one.

So far, I've managed to do this:

1) Look for all Excel files in a given folder and display their names in Column B (i.e. from Cell B9 down).
2) Generate a password in Column C (i.e. from Cell C9 down) automatically based on the filename - I've built this in to the macro I built in step 1.


And now I've hit a snag. I now want to loop through each file from the list in Column B (from B9 down) and assign the corresponding password to it from Column C (from C9 down). I wrote the following code for it, but it doesn't seem to work:

==============================================

Please Login or Register  to view this content.

==============================================


Any ideas??


Thanks in advance!