|
|
|||||||
Hi I am using udfPassword function. I am creating password for mailaccounts. The problem is that I am printing the password in excel and there you cant see the different between big i and little l. Can I generate password and exclude some letters ? |
||||||||
|
|
|||||||
I have done the following code: Code: ; Create password with no i or l characters $x = 0 While $x < 25 $x = $x + 1 Sleep 0.5 SRnd(@msecs) $Password = udfPassword("Aaacnnnn",,"il") ? "." For $Count = 1 to 8 If SubStr($Password,$Count,1) = "i" Or SubStr($Password,$Count,1) = "l" ? $Password EndIf Next Loop What I can read the function udfPassword should NOT produce any iIlL but when I run this code the password can have these letters. |
||||||||
|
|
|||||||
Please take a look at this script from Richard. I was going to write a fancy KiXform for this but ran into some issues with the graphics that I couldn't sort out and then Shawn went missing so I've dropped it for now Excellent UDF script though, just no GUI for it at this time. Flexible password generator http://www.kixtart.org/forums/ubbthreads.php?ubb=showflat&Number=158693 . |
||||||||
|
|
|||||||
I don't see how this is strictly a UDF/kix issue - just change the font in Excel to Courier - any serif typeface, actually, and the difference will become clear. Using a fixed-width font like Courier will also lessen any chance for mis-reading the password, especially if it is a complex sequence. Glenn |