Website log in

[josros60]

I have spreadsheet with the following columns:

1. Vendor name
2.website link
3.user
4.password

How to write a vba code to log in website and get user/password from cells.

Any sample Please.

Thank you

 

[Rijnsent]

Hi Josros,
try searching for "excel vba web scraping log in", you'd find help like:
http://dailydoseofexcel.com/archives/2011/03/08/get-data-from-website-that-requires-a-login/
https://www.myonlinetraininghub.com/web-scraping-with-vba
http://www.excelvbasolutions.com/2014/08/web-scraping.html
They give the blocks of code you'd need to get that up and running.
Cheers,
Koen