Password generator for application rollouts

[aw12]

To roll out an application initially, I would like to develop a spreadsheet where there is a choice of sample formulas that a person could choose based upon length and complexity, or plug it in for input.

In one column would be usernames or email addresses, and in the second column would be the formula for passwords, which could be dragged to cells below. I envision using mail merge to to send the information out to individuals.

There is a very interesting string at: http://www.excelforum.com/excel-prog...generator.html that I believe could assist, but then again, perhaps a VB script would work, too.

[scott.s.fower]

put this code in the sheet code, right click the tab where you want the code to run and select view code, paste it in