Website VBA Macro Question

[excelcandy]

I am new to vba programming for excel and need some quick help to get a macro that logs me into the following website
https://google.com
After that I want the macro to click on a link.
What would the macro be forthat?
Thanks in advance

[djdjdj]

Hi. I can't really take credit for this code, I had a similar task once so I ended up with this after many google searches and combining various other codes. But anyway, here you go. Just fill in your username, password, and the link address and you should be good to go.

Please Login or Register  to view this content.

[excelcandy]

Hey, that's almost perfect, but the password field isn't getting filled in and it still tries to log in. Stops.

[djdjdj]

hmm, not sure why. When I run it it fills in the password field with PASSWORD. Try putting this:

Please Login or Register  to view this content.

between "End if" after username and "If" before password and see if that helps.

[excelcandy]

Hey, this worked, but it should open a new window after the login. atm it ends the macro.

[excelcandy]

Hey,

Is there a way to keep the macro on track when changing windows?

[djdjdj]

not sure what you mean exactly. did you manage to get the macro to follow your link after logging in? If not, find this line in the code:

Please Login or Register  to view this content.

and remove the ' before IE.

[excelcandy]

This worked fine. thank you !!!!!