Im looking for an alphanumeric password generator either program or macro to create 6 digit pass codes. All the codes must contain numbers and letters as i wish to create a password system for a spreadsheet I have. I have the basic idea but it will only accept a lettered password and i wish to make it more secure.
Any ideas or links will be appreciated.
TIA
Last edited by ukphoenix; 10-13-2011 at 03:39 AM.
Please Login or Register to view this content.
@ukphoenix:
I came up with a non-VBA solution (see attached), though its a bit more comprehensive than what you originally asked for. It is a .xlsx file so it requires excel 2007 or higher to view. Just set the parameters you're looking for and press F9 to generate a new password until it gives you one you want. Then you can copy/paste the password into a notepad or word doc to keep it. If you'd like to see what's going on behind the scenes, the worksheet protection password is "123" (no quotes), and columns A:K are hidden.
Last edited by tigeravatar; 10-12-2011 at 02:42 PM.
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
or
Please Login or Register to view this content.
Thanx all, i can work with these.
Have a look at this funny link and bear in mind that 6 case-sensitive alphanumeric digits isn't very secure.
It's even less secure as people aren't very good at remembering 6 randoms characters and so are massively more likely to write down the passwords somewhere.
Re: Random alphanumeric generator
Do you have any ideas on how we can take your formula and apply it in a column for more than one at a time?Originally Posted by tigeravatar
I envision a column with usernames and then a column for passwords, then using mail merge to send them out.
aw12,
Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
I like it.
or
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks