Check Data against a website

[Gary Abley]

Good Afternoon,

I quite new to excel VBA so sorry if I've not posted correctly.

I was wondering if there I away to run a Macro that will check a MOT date and return the date the MOT is due.

I.e if I have got a registration number in cell A1 and another registration in A2 and so on, I won't the VBA code to open a website search for the registration number in column A and return the MOT date due in the corresponding cell. Hope this makes some sort sense of what am trying to achieve?

I'm not sure if this can be done but any help would be appreciated.

The website that I have been using to Check the MOT Date is https://www.confused.com/on-the-road/mot-status-check



Kind Regards
Gary

 

[Joe4]

It looks like you re-posted the question here: https://www.mrexcel.com/forum/excel-questions/1110715-pull-multiple-values-website.html, with more detail.

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules). If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.

Since your other thread seems to be more detailed, I will lock this one and leave the other one open.