How to load data from Excel into a browser webpage?

[Chartist]

I have data in an Excel sheet and a hyperlink corresponding to each record (row). I click the link in the Excel cell and it opens in a new tab in Chrome.

The webpage has fields which need to be filled using the data in the Excel sheet. I'm currently copy-pasting this from the Excel sheet to the webpage I just opened.

What's the best way to auto-fill the webpage with the data in Excel? (Hopefully something in Excel/VBA, but otherwise how do I go about this requirement?)

Thanks!

 

[Chartist]

(bump)

 

[John_w]

You can do this by automating IE or Chrome with VBA. Doing it via Chrome requires the installation of the Selenium library and ChromeDriver, which you might need to re-download and reinstall to match your current Chrome version. Doing it via IE is easier because it doesn't have these installation overheads, however your web site might not work with IE11. There are some useful posts in this thread:

Web Scrape Error : getElementsByClassName

Hi all, Really grateful if someone can help me with the below. I am trying to get some news links from the website in the below code. It previously used to work fine and recently is causing issues, but I can't seem to figure out why. In terms of what the code should be doing is extracting the...

www.mrexcel.com