Re: Need Password Generator for 10 users

Carmine782 wrote:
A Passowrd Generator/Manager is security program that stores and
suggests or genrates really strong passwords for all users on your
network.
[...]

Password generator? Roll your own!

I get my userlists (school, 700 new users each year) in Excel file format, and need to generate individual passwords before importing into the user directory. I made a generator from the following parts:

- One cell with a "base string" of permitted password characters.
- Cells with a formula for extracting a random character from that string
- One cell that makes the password string from those cells
- A macro that copies the password string to each user record

Now I generate those passwords in a minute.
For pronounceable passwords, make two base strings, one with vowels and one with consonants. Make the final password from alternately consonant and vowel.
For strong passwords, use upper and lower case as well as digits and punctuation, and variable password length.
When users are supposed to read the password, there are characters which are easily confused. Avoid those. e.g.: Digit "zero" and uppercase letter O ; Lowercase letter L, uppercase letter I and digit "one"

Password manager? Doesn't that defeat the purpose of "really strong passwords"? (Same password stored twice, possibly with different encryption, increases the amount and/or availability of source data and makes extraction and decrypting easier.)
.

Relevant Pages

  • Re: Counting Upper and Lower case chars in a Cell
    ... works for all lowercase and uppercase letter. ... Replace A6 with the address of whichever cell has the string in ... and enter as array formula: ... If cell A2 contains an upper case letter - Cell D2 will show a numeric ...
    (microsoft.public.excel.misc)
  • VB, implementing the high score within this code
    ... Private possibleAs String ... Private Function SolvePuzzleAs Boolean ... ' Calculates the possible values for all the cell ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Formulas containing hard coded values
    ... Dim R As Range, sdoit As String ... MsgBox "Cell contains hard codes" ... Dim Fml As String, LCtext As String ... For Each Rng In R.Precedents.Areas ...
    (microsoft.public.excel.programming)
  • Re: Marking points read for coordinates
    ... In "Private Sub GetCoordinates()" comment all the code between ... (ByVal lpClassName As String, ByVal lpWindowName As String) ... ' cell A1 which is the base for all object coordinates on a sheet. ... Dim chtObj As ChartObject ...
    (microsoft.public.excel.programming)
  • Re: Text formatted cells displaying numbers in scientific format
    ... When it 'sees' a large number it uses scientific format since ... I accept that Excel can't handle numbers greater than 15 digits and your ... string was 16 digits or more to be converted to a scientific value. ... It just doesn't display correctly in the cell (except after entering ...
    (microsoft.public.excel)