Web Scraper Function Vessels data

Hi all,

I want extract some data from multiple webpages several time a day. I already tried some things, but can't get it to extract the proper data. I want to do the following:
Extract the Latitude / Longitude from for example the following vessel: http://www.marinetraffic.com/en/ais/...:SEISHU%20MARU

I want to do this for all LNG vessels several time a day. Does anyone have a tip on how to do this with a fast working function/macro.

Thanks in advance

The website has a subscription API service, so that will likely be much easier to use. Have you looked into that?

Yes I did, but it's for a study project and I don't have the resources to pay for the subscription. And I thought it might be a cool project to automate it from one excel sheet.

Do you have the urls for all the ships you want to track?

Yes.
My initial plan was to put all the URL's (400 in total) or the last part of the URL that changes, in for example column A. Than with a function set a formula in column B that refers to A and extract the Latitude / Longitude value from the page.
But I don't know how to build this function. Any ideas?

You probably wouldn't do it like that. Could you upload a workbook with your links in please?

How To:

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Marrina Traffic.xlsxMarrina Traffic.xlsx

Thanks Kyle!

This'll work (ish), the range will need changing accordingly, you'll also find that sometimes it doesn't work - I think the site are limiting request in a short period to prevent automated scraping

Please Login or Register  to view this content.

End Sub

Hi Kyle! works like a charm! Thanks!!