VBA to copy data from Website HTML format to Excel

[MaunishP]

Hi Team,
I have couple of websites which i need to scrub data from html format to excel format. Below given are steps which i perform daily :

1) Open Website : http://registers.maryland.gov/main/search1.html
2) Select County from the drop down
3) Select date range for last 3 months
4) Search
5) Then i need to copy data and paste it into excel then click 2 tab and copy data and paste into excel.

Is there a possiblity to copy data from html and paste and go to next search and again copy data and paste ?

Regards,
Maunish Patel

 

[Marc L]

Hi,

if data are in an HTML table, you can use the clipboardData object
for example, see this thread …
​