Hi,
I have a particular software which contain my client user name and it's password along with other misc details like address full name etc.
Client password going to expired after every three month. I have sheet which column A contain user name and column b for password.
Client password in text file is written after user name like
I would like to use excel vba to search the text file for particular user name and copy password in excel sheet.
Is there any code I could use to solve the problem? Thank you for your help.
I have a particular software which contain my client user name and it's password along with other misc details like address full name etc.
Client password going to expired after every three month. I have sheet which column A contain user name and column b for password.
Client password in text file is written after user name like
VBA Code:
sampleusername password1
sampleusername1 password2 sampleusername3 password3
I would like to use excel vba to search the text file for particular user name and copy password in excel sheet.
Is there any code I could use to solve the problem? Thank you for your help.