Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
changing password | Excel Discussion (Misc queries) | |||
i have forgotten the password i made for an excel document | Excel Worksheet Functions | |||
Changing column of numbers made of formulas to just numbers | Excel Discussion (Misc queries) | |||
drop-down list changing according to choice made | Excel Worksheet Functions | |||
Changing the format of an Excel output file made by Microsoft Access | Excel Discussion (Misc queries) |