Good morning,
I currently I have a macro that goes out to a website and logs in using the send keys but I would like to modify the macro to login using the username and password value in the source code instead of the send keys. However, I’m just starting to learn how to use VBA to communicate with Internet Explorer and I’m not sure how to do it.
Can someone please navigate to https://appraisalport.com/ and view the source code and let me know if you can come up with a way to post a value to the username and password field? If you can give me the base code, I should be able to figure out the rest.
Also, does anyone know of a good book that I can get to learn how to use VBA to communicate to Internet Explorer?
If you have any questions or need additional information, please let me know and I’ll respond right away.
Thanks,
Rick
I currently I have a macro that goes out to a website and logs in using the send keys but I would like to modify the macro to login using the username and password value in the source code instead of the send keys. However, I’m just starting to learn how to use VBA to communicate with Internet Explorer and I’m not sure how to do it.
Can someone please navigate to https://appraisalport.com/ and view the source code and let me know if you can come up with a way to post a value to the username and password field? If you can give me the base code, I should be able to figure out the rest.
Also, does anyone know of a good book that I can get to learn how to use VBA to communicate to Internet Explorer?
If you have any questions or need additional information, please let me know and I’ll respond right away.
Thanks,
Rick