Auto Login to Website with Click of a Button Using VBA

Hello. I included a workbook showing what i'm trying to achieve. I have bills, accounts, forums, etc. They all have passwords. It would be nice to go to pay a bill, check my email, nerd out on a forum, and not have to remember one of the thousand Usernames/Passwords that I have. Just have a series of buttons that can be clicked, that link you to the site, and auto fill in your login criteria. I gave hyperlinks to the first three buttons as an example. Now I'm looking to see if any of you super geniuses out there might know of a way to work thru the Login/Password portion of it. I'd greatly appreciate the help. Tks.

https://stackoverflow.com/questions/...g-vba/24250879

Thanks. I'll give this a shot and see if I can get it working. Appreciate the help.

I found the code below at the below link but it doesn't seem to be working to log in to Gmail. Any Thoughts?
https://www.exceltrainingvideos.com/...automatically/

Please Login or Register  to view this content.

.
Jim

I've just spent the last few hours searching the Forum, other forums and the internet in general trying to find an answer for you ... without success.

I attempted 1/2 dozen other examples provided by different authors. The closest I can get is the USERNAME and the screen asking for the password.
Every example I tried stops at this point.

I am hoping another volunteer on this FORUM can assist you with this. Will check back to see how it progresses.

Maybe look at Autohotkey;

https://www.autohotkey.com/

Yeah that's the same issue I run into. The video in the link makes it looks so simple and flawless though...so certainly it has to work, because videos and the internet don't lie, right?...sarcasm aside, I appreciate all the time and effort spent. I've been seeing if maybe I can piece a few different codes together but my limited knowledge of VBA is making that a bit of challenge. Checking out "www.autohotkey.com" now. Fingers crossed. Thanks again for the help.

.
You are welcome.

Why not just use a password manager? More secure and they can do this out of the box?

I have an home budget spreadsheet that doesn't get used as often as it needs to. I'd like to change that. Suck it up and be a grown up. Part of the reason it's not getting used is because bills come in and you have to go to multiple locations to balance the budget; spreadsheet, password books, the site to pay the bill, etc. The train of thought was to take this ultra fancy sheet that so many hours were spent on, dust it off, add some shiny buttons that you can click and have them auto connect you to the appropriate site. I could even go so far as to add some conditional formatting so that they change colors when a bill is due. The Gmail portion is a necessary component of that. And the whole thing would be password protected. One password, verses several. So, that's the game plan. Trying to work on my grown up skills because they are sub par at the moment.

I GOT IT!!!! I'm not a thousand percent certain what I did but I got it working. Basically, after spending all day researching, I changed all the punctuation (" ' - > etc.). After that, I went into VBA tools and checked off Microsoft Internet Controls, and Microsoft HTML Object Library. Then swapped the username and password and got rid of what I presumed were instructions written in there. And it works. New code posted below. Just replace "[email protected]" with your email address and "password123" with your password and it should work. Good luck. Still in shock over that one.

Please Login or Register  to view this content.

.
Mr Clayton ... YOU DA MAN !

I had tried some of what you did but obviously didn't get it right. Great work !!!!

Thanks...gonna chalk that one up dumb luck and perseverance. Of course I’ll lead everyone else to believe that it’s just a result of my excessive super genius abilities. I appreciate all the help. Now I just have to figure out login code for Everything else on my list.