How To Create A Fully Automated User Password Reset In Excel

Поделиться
HTML-код
  • Опубликовано: 22 ноя 2024

Комментарии • 89

  • @ExcelForFreelancers
    @ExcelForFreelancers  5 дней назад

    😱 𝗨𝗡𝗕𝗘𝗟𝗜𝗘𝗩𝗔𝗕𝗟𝗘 𝟲𝟱% 𝗢𝗙𝗙 𝗧𝗛𝗜𝗦 𝗕𝗟𝗔𝗖𝗞 𝗙𝗥𝗜𝗗𝗔𝗬! 👉 www.excelforfreelancers.com/BFSale2024_YTPinnedComm

  • @Jojosmith342
    @Jojosmith342 Год назад +1

    millions thumbs up to the greatest VBA teacher on earth Randy. Thanks for the valuable lesson

    • @ExcelForFreelancers
      @ExcelForFreelancers  Год назад +1

      For sure, you are very welcome Jojo. I am glad I could help and share

  • @chiwilanjabulosikwila3487
    @chiwilanjabulosikwila3487 2 года назад +1

    Mr. Austin. You are an Excel WIZARD!! Liked the random password generator logic. Very neat.

  • @kailashsoni676
    @kailashsoni676 Год назад +1

    Thank you sir❤️
    That's what I was looking for
    Amazing tutorial
    🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏

    • @ExcelForFreelancers
      @ExcelForFreelancers  Год назад +1

      For sure, you are very welcome and I am happy I can help. Thank you for your Likes, Shares & Comments. It really helps.

  • @karimhati4318
    @karimhati4318 4 года назад +1

    Dear Randy, you are the best .

  • @johnbutler2750
    @johnbutler2750 5 лет назад +1

    This is clever, you could use this to get users to link their name application.username to an email, then have them verify it by sending a temp password, removing the need for an admin to add new users. Could even run on startup if username don’t match table in hidden sheet

    • @ExcelForFreelancers
      @ExcelForFreelancers  5 лет назад +3

      Hi John, that is a nice idea too. If it is a large application with lots of users and an admin wants users to be able to register, we could add a 'self-registration' certainly. Thanks so much for the comment and idea. Much appreciated.

  • @rarbusinessinstitute
    @rarbusinessinstitute 4 года назад +2

    Awesome Tutorials.....How do I combine multiple user log in with password reset.

    • @ExcelForFreelancers
      @ExcelForFreelancers  4 года назад

      HI and thanks Rar I have a video on multiple users in which you can use here: ruclips.net/video/0ahYoy5L3ec/видео.html

  • @steveniejalke1682
    @steveniejalke1682 5 лет назад +1

    Another GREAT tutorial Randy. So many cool things to do with Excel. Look forward to Tuesdays!

    • @ExcelForFreelancers
      @ExcelForFreelancers  5 лет назад

      Thanks so much Steve, next week we will be tabbing through cells AND shape based buttons. Most likely something you have not seen in Excel yet. Much appreciated.

  • @rohitgurung909
    @rohitgurung909 5 лет назад +1

    This is really wonderful....You are an inventor....I greatly appreciate all your work.....Keep it up Randy....Thank you so much for this valuable video

    • @ExcelForFreelancers
      @ExcelForFreelancers  5 лет назад +1

      Thank you so much Rohit, I am really glad you enjoyed the training

  • @chrisk.2957
    @chrisk.2957 11 месяцев назад

    I love it!!! Thanks so much, Randy!!!

    • @ExcelForFreelancers
      @ExcelForFreelancers  11 месяцев назад

      Thank you so very much, I really appreciate that Chris.
      Thank you for your Likes, Shares & Comments. It really helps.

  • @mzsh1801
    @mzsh1801 5 лет назад +1

    You always have new thought.
    I have learned alot from your video.

  • @animatedmovies7118
    @animatedmovies7118 2 года назад +1

    Very good and Informative Video
    i am not able to download the project can you provide the link which work so its easy to us to download conveniently
    i have a question. beside Outlook can people receive Password Reset Key in gmail also
    not all have outlook account
    i am impressed with your video

    • @ExcelForFreelancers
      @ExcelForFreelancers  2 года назад

      Hi If you have tried to download this workbook using the links but had a problem please email Shane@ExcelForFreelancers.com . Please supply the email you used along with the workbook you are requesting. Thanks for your patience.

    • @animatedmovies7118
      @animatedmovies7118 2 года назад +1

      @@ExcelForFreelancersI Got the File thanks
      is your Program Internationally recognized just asking for my understanding only

    • @ExcelForFreelancers
      @ExcelForFreelancers  2 года назад

      Hi and thanks for your comment. I have hundreds of programs and application so I am not sure which one you are referring to. My channel is a global channel however. I hope this helps and thanks so much.

    • @animatedmovies7118
      @animatedmovies7118 2 года назад

      @@ExcelForFreelancers if we link gmail account in outlook can we reset password using gmail in outlook
      i didnt understand that video u publish before gmail password reset
      Thanks

  • @frantonio1209
    @frantonio1209 4 года назад +1

    Great job as usually. I have a suggestion, why don't insert in the First User Form "LOGIN" a CheckBox and then disable and Enable it if the User is Authorized to change password. Sorry did not mean to be offensive.

    • @ExcelForFreelancers
      @ExcelForFreelancers  4 года назад

      Hi and thanks there are many ways that this can be updated for your own requirements. A nice suggestion indeed. Please feel free to download this and customize it however you like. Thank you for your Likes, Shares & Comments. It really helps.

  • @9pp9p9pp
    @9pp9p9pp 5 лет назад +1

    Hi Randy, another great video, I love how your logic and easy to follow coding inspires others to accomplish what might otherwise seem a mammoth task. Well done 👍

  • @nerenlakhraj5252
    @nerenlakhraj5252 5 лет назад +1

    Hi Randy ... thank you as always for the continuous inspirations and ideas that you come up with to teach us. Simply awesome. Suggestion or is the a way that when new passwords are generated, that is contains Upper, Lower, Alphanumeric & Special Characters. I ran this this thru password meter in terms of strength & complexity & it comes up very weak. I know you always surprise us with your talent and skills and once again thank you.

    • @ExcelForFreelancers
      @ExcelForFreelancers  5 лет назад

      Hi Neren thanks so much. There are so many ways that developers can require specifications on passwords and I think that is really important. In Today's video we will focus on how users can reset their own passwords, without specifying required formats of those passwords. In future videos I will show you how to require specific formats for strong passwords for their users. Thanks again for your continued support and suggestions.

  • @jonminer9891
    @jonminer9891 5 лет назад +1

    Thanks, Randy. New user here.

    • @ExcelForFreelancers
      @ExcelForFreelancers  5 лет назад

      You are welcome Jon and so great to have you. IF you like this training please check out the original training for this application which allows users to share and sync their Excel applications from around the world: ruclips.net/video/aKV5seZmiBs/видео.html

  • @jackmandu
    @jackmandu 4 года назад +1

    Great video. If this function is used in the shared environment is there a risk that two or more people are trying to reset their passwords simultaneously or close together and the reset key won’t match by the time the first person tries to use it and reset their password?

    • @ExcelForFreelancers
      @ExcelForFreelancers  4 года назад

      Hi Jack, thanks for your comment. It should not be an issue if you run a 'Share & Sync macro' right before a new password is assigned, this way there would be no conflicts. Thanks for the great question.

  • @Excellent625
    @Excellent625 5 лет назад +1

    Hi Randy,
    Thank you very much for your great videos. We really appreciate all the efforts you do for us as Excel and vba lovers. On yhr other hand, I have a question which is very important to me. My question is related to a previous video which was poart of today's one (How To Share and Sync Your Macro-Enabled Excel Workbook, from Scratch, With Anyone). Frankly speaking, I did not get the idea of sharing an Excel file which has many vba codes with others through a shared folder in One drive. Don't you think when putting any Excel file with vba in clouds the vba won't work. Please clarify this point which is very important to me.
    All the best,
    Thamer
    Excellent

    • @ExcelForFreelancers
      @ExcelForFreelancers  5 лет назад +1

      Hi Thamer, thanks for your comment and I appreciate your concern. The reason it works so well is that each user has their OWN excel application. The application does not have to be in a shared folder. It works because ONLY the changed data goes in the shared folder. When data changes, each individual excel application is updated with the new data. I will be developing a large accounting application with this share & sync feature in our Mentorship Program starting this month, so for sure you will want to check that out as well.

  • @VenemAcademy
    @VenemAcademy 5 лет назад +1

    Hi Randy, why is there a semicolon after Else: in the if...then...else construction. That wasn't necessary before if I'm not mistaken

    • @ExcelForFreelancers
      @ExcelForFreelancers  5 лет назад

      Hi Eric, I often use a colon, however it is not always necessary in newer versions of Excel. (probably just an old habit) Thanks so much for your feedback, much appreciated.

    • @ExcelForFreelancers
      @ExcelForFreelancers  5 лет назад

      Hi Eric-Jan, this can be removed, Sometimes i add colons, however semi-colons should not be used. I hope this helps and thanks for your feedback. I have made the necessary updates on the download version. Much appreciated.

  • @khadimhussainmomin1315
    @khadimhussainmomin1315 2 года назад +1

    Hi i m Momin from India, i m big fan of you. I love your hard work. Thank you.
    Is it possible to send OTP instead of Mail

    • @ExcelForFreelancers
      @ExcelForFreelancers  2 года назад

      Hi and thanks very much. It may be possible however I have not tried that method. If i get enough requests I can do research and add it in a future training if possible.
      I hope this helps and thanks so much.

  • @VenemAcademy
    @VenemAcademy 5 лет назад +1

    Hi Randy, learning so much of Your videos. Thnx! Does this premiere cover encrypted passwords in the data sheet as well?

    • @ExcelForFreelancers
      @ExcelForFreelancers  5 лет назад +1

      HI Eric, thanks so much and glad you like it. In this video I will be showing you how to create an 8 character random security key, however I do not cover password encryption. The Admin sheet should always be 'xlVeryWellHidden' from non admin users when setting up your application.

  • @ashoksahu9546
    @ashoksahu9546 5 лет назад +1

    Awesome video. Thank you so much sir.

  • @SyedMuzammilMahasanShahi
    @SyedMuzammilMahasanShahi 5 лет назад +1

    Thanks for this beautiful share.

  • @nileshjaiswal9738
    @nileshjaiswal9738 4 года назад +1

    Sir can you please teach how to put an licence key on Excel software same as any professional software which can be activated from our side

    • @ExcelForFreelancers
      @ExcelForFreelancers  4 года назад

      Hi thanks very much. I am teaching that in my Mentorship Program. You can find all of the details right here: bit.ly/MentorshipProgram_YTCom

  • @nextgenhype6488
    @nextgenhype6488 5 лет назад +1

    Awesome video! Keep up the good work👌

  • @rexryanmalbacias6865
    @rexryanmalbacias6865 5 лет назад +1

    Can this be use in google drive for office work? If not, how can I connect everyone (my office-mate) so that we can input data simultaneously if we don't have LAN? I might have some more questions along the way sir Randy, cause I'm a nurse and not and I.T. ;)

    • @ExcelForFreelancers
      @ExcelForFreelancers  5 лет назад

      Hi Rex, thank you for your comment. The answer is Yes, you can use any shared folder including DropBox (which I think is the best), Google Drive, or Microsoft One Drive. Each user would need to have the shared folder software installed on their computer and each user would have to have shared access to this folder. Each user would have their OWN application and only the Data itself would be shared (not the excel file)
      There is a full training of how this would work here, however it does require vba skills, ruclips.net/video/aKV5seZmiBs/видео.html
      The application is open and you are welcome to customize this to fit your exact requirements, however, If you would like some help with this, we have a group with 20,000 Excel experts who would love the opportunity to customize this for you. Please join our Excel For Freelancers Facebook Group here: bit.ly/groupexcel (if you have not done so yet)
      You can then create a post and mark it as a PAID JOB, along with all of the details and requirements. Our members can then contact you and decide on how to best move forward with your project.
      I hope this helps and thanks so much.

  • @Alex287S
    @Alex287S Год назад +1

    After you change the password for a user, close and safe the workbook and open it again to change the password again for the same or any other user, it is always the same key - SNPHHUAT. There is something wrong with the code. Can you post the correction? Thanks.
    Update: You forgot to put after For loop in module SendPWEmail.

    • @ExcelForFreelancers
      @ExcelForFreelancers  Год назад

      HI and thanks so much. Running the macro on workbook open will take care of this. Thank you for your Likes, Shares & Comments. It really helps.

    • @Alex287S
      @Alex287S Год назад

      @@ExcelForFreelancers Your work is really great.

    • @ExcelForFreelancers
      @ExcelForFreelancers  Год назад

      Thank you so very much, I really appreciate that

  • @gadavis500
    @gadavis500 4 года назад

    Hi Randy... your email macro works only for Outlook. Many folks use gmail or something else.. So, would you not need to have something that would work for any kind of email. Seems I remember you had a routine that would always work..... just wondering why you don't use it instead or at least mention it.

    • @ExcelForFreelancers
      @ExcelForFreelancers  4 года назад

      Hi Glenn, thanks for your comment. I have an entire video on sending emails without outlook here: ruclips.net/video/WoCuRFEuACg/видео.html

  • @forhadkhan3101
    @forhadkhan3101 2 года назад +1

    Nice video

  • @SuperKucinghitam
    @SuperKucinghitam 5 лет назад +1

    Nice, thanks...

  • @animatedmovies7118
    @animatedmovies7118 2 года назад +1

    how to reset password using Gmail like the steps in How To Create A Fully Automated User Password Reset In Excel video
    using gmail video it shows different method
    kindly make video of how to reset gmail also mention like this video done
    thanks

    • @ExcelForFreelancers
      @ExcelForFreelancers  2 года назад +1

      Hi and thanks. i am really not sure as I have not tried that with Gmail.

    • @saleemfaruqi781
      @saleemfaruqi781 2 года назад +1

      @@ExcelForFreelancers if I use outlook method if gmail users user that same steps
      Since you are professional can you try to make video based on non-outlook
      Not all people have outlook
      Thanks

    • @ExcelForFreelancers
      @ExcelForFreelancers  2 года назад

      Hi and thanks. I have that here: ruclips.net/video/WoCuRFEuACg/видео.html
      Thank you for your Likes, Shares & Comments. It really helps.

  • @amrataa8825
    @amrataa8825 4 года назад +1

    Hello,
    I have a problem with excel vba..
    I created a full excel macros vba file and program it to open/save all userforms automatically and hide excel file.
    I forgot to create a button to enter to excel worksheet file.
    There is a way to open this excel worksheet file to make more edits.?
    Thanks..

    • @ExcelForFreelancers
      @ExcelForFreelancers  4 года назад

      HI Amr, you should be able to open it without macros enabled and then use Alt + F11 to enter the VBA Editor to make changes. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel

  • @JustinS1981
    @JustinS1981 5 лет назад +1

    How can I make it to where the user is required to use the correct case? Right now, the user can login as long as the characters match...even if it doesn't match each upper or lower case for the password.

    • @ExcelForFreelancers
      @ExcelForFreelancers  5 лет назад

      Hi Justin, thanks for your message. I will be creating a new training on password security and matching case very shortly so this should, however a simple value to value comparison will be case sensitive. You can find more details here: www.automateexcel.com/vba/case-sensitive/

  • @TheJaebeomPark
    @TheJaebeomPark 4 года назад +1

    Amazing

  • @SantoshKumar-pj5nb
    @SantoshKumar-pj5nb 5 лет назад +1

    Code for receiving password reset key in mail is creating an Error.... please help me to understand that

    • @ExcelForFreelancers
      @ExcelForFreelancers  5 лет назад +1

      Hi Santosh, thanks for your message. I have created a Facebook group with 23,000 Excel Experts so that many of us can help you with your Excel questions. Can you please post your detailed question, with samples or screenshots directly in our group? If you have not Joined yet, please join here: bit.ly/groupexcel. This way we can get you the answers you need, fast.

    • @SantoshKumar-pj5nb
      @SantoshKumar-pj5nb 5 лет назад +1

      @@ExcelForFreelancers Sir, I have sorted out the bug and removed it...... Thanks Sir for your wonderful videos...I am unsatisfied.... because the more I see and learn from you I feel like I have to learned more from you...it become that I am addicted to your videos..... Keep Flowing Sir

  • @harun-or-roshid6287
    @harun-or-roshid6287 4 года назад +1

    In Outlook 2007 below code will be worked properly ?
    Set OutApp = CreateObject("Outlook.Application")
    Set OutMail = OutApp.CreateItem(0)
    With OutMail
    .to = Sheet2.Range("B13").Value 'Email Address
    .Subject = "Your Password Reset Key Is Here"
    .Body = "Hello " & Sheet2.Range("B11").Value & vbCrLf & _
    "Please use the following password reset key to reset your password:" & vbCrLf & _
    PWText & vbCrLf & "Thank you very much, Admin"
    .display '(You will want to change this to .Send)
    End With

    • @ExcelForFreelancers
      @ExcelForFreelancers  4 года назад

      Hi thanks this should work but please give it a try. If you run into any bugs or issues that you cannot figure out, please feel free to upload the details and screenshots in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel
      We have 25,000 Members who would love to help you with this. Thanks so much.

  • @radheprajapati2036
    @radheprajapati2036 5 лет назад +1

    Amazing not for for you this trick......