rosscoexcelmonster
New Member
- Joined
- Aug 1, 2013
- Messages
- 8
Hello everyone,
I was wondering if you could help me with something that would be truly invaluable to my work life!
I already have the first 2 pieces of the puzzle, however, my knowledge doesn't allow me to complete the solution.
1. I already have a macro that lists all of the workbooks within a specific folder - it returns a complete list of their full file paths and outputs them within a single column (column A)
2. The second macro generates random passwords in the column B, next to all of the listed workbook file paths in column A.
3. This is where you knowledgeable gurus come in: I need to create a Macro that allows me to password protect each of the different work books in the left column(column A), with adjacent, random password generated in the right column (column B)
I really appreciate you guys taking the time to ready this. Hopefully you can help! If not, thank you all the same!
I was wondering if you could help me with something that would be truly invaluable to my work life!
I already have the first 2 pieces of the puzzle, however, my knowledge doesn't allow me to complete the solution.
1. I already have a macro that lists all of the workbooks within a specific folder - it returns a complete list of their full file paths and outputs them within a single column (column A)
2. The second macro generates random passwords in the column B, next to all of the listed workbook file paths in column A.
3. This is where you knowledgeable gurus come in: I need to create a Macro that allows me to password protect each of the different work books in the left column(column A), with adjacent, random password generated in the right column (column B)
I really appreciate you guys taking the time to ready this. Hopefully you can help! If not, thank you all the same!
