Changing a made up password
This isn't so much a workbook security question as it is just a basi
programming question. I'm a total newbie on this and only have C++ an HTML experience, but I understand how macros work also (it's prett basic, but I have used them). I have two worksheets, one with a list of sites. Each site is assigne a password through a very simple proccess. Each site is actually a 1- digit number. I split the digits up, and multiply each digit by a see number of 4-7 (depending on how many digits the site has), and the concatenate that with standard text. Here's an example. Site 766 Value-----------Seed-------------Key-------------PW --7-----------------6-----------------42-------------dog42 --6-----------------5------------------30------------dog30 --6-----------------4-----------------24-------------dog24 A 4-digit password would have its first digit start with 7 as a seed. So I got that working. I created a worksheet in which you enter in site number, and it pops out a password. Easy enough with simpl functions. Now, I have a separate database of site numbers. I've als included their respective passwords. One digit sites have only password, but 4 digit sites have 4. Each site begins with their firs password (dog42 in the ex) as their current password. But, when th user wants to, he/she just enters in their site number in that form mentioned earlier, and it should pop out the next password. If it onl has one pw, it will output the same one. If it's on its last pw, i will output its first again. In my database sheet, I added a column for the current pw, and a colum for the next pw. The problem I have is updating them once a user enter a site number. Can this be done with macros? Thanks in advance for an help -- Message posted from http://www.ExcelForum.com |
Changing a made up password
For further reference, here's my "database worksheet"
V=Value, S=Seed, K=Key, and PW=Password. There are actually 4 of eac column like mentioned above. Site #-----V1---V2---S1---S2---K1---K2---PW1---PW2----CurrentPW 1 -----------1-----------4----------------------dog4--------------dog4 21----------2-----1----5----4-----10---4----dog10---dog4----dog10 etc etc... I don't know if my last column will show since I maxed out the tex box, but there's another column that is NextPW that has the nextPW i line. Now, I need another worksheet, I'm assuming I have to use form object but i'm not sure. I'd like as little programming as possible since have no VB experience. I need something where the user enters in a sit #, it will look through the list and output the current PW and then th new one. In that process, it will change CurrentPW in the list to it NextPW value, and change NextPW to whatever is supposed to be next o the list. I'm sure you get the idea. :) Thanks for any help -- Message posted from http://www.ExcelForum.com |
All times are GMT +1. The time now is 08:37 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com