Return values in batch via custom web query based upon cell value?

Hey,

Need help with this one. I want to create a web query that is using cell values from A2 and onwards in

the Excel thatīs provided. The data that I want to fetch is based upon the format

www.missatsamtal.se/operator.php?nr=CELLVALUE

Eg. If cell value A2 is 1111 then Excel shall fetch the data result from the link

www.missatsamtal.se/operator.php?nr=1111, value A3 (the next after A2) is 2222 then
Excel shall fetch the data result from the link www.missatsamtal.se/operator.php?nr=2222

Pretty much what Im trying to do is to enter a bunch of phone numbers, that later on uses the URL

"www.missatsamtal.se/operator.php?nr=" and retrives the answer for each value.

So to summarize;

1) I want to enter a phone number in column A (Green)
2) I want to see what the webpage returns, and for this to be shown in column B, using either like Excel VBA, macro or Web query.

Iīve added how the link/url should be built up, and what the webpage returns if this is done manually.

I hope that my description is understandable

Thank you guys so much!

//Freddie

Thank you for the quick response, but...

I only get a compilation error , please see attatched image. Is there a chance that you can run the same thing to see if you get the same error, or am I doing something wrong here?

regards,
Freddie

Thanks alot!