How can i pull data from web into excel cell?

[pushpu]

I have a public json URL that outputs a digit.
How can i have a certain excel spreadsheet cell pull the data from that URL and use that data?

[Luuk]

The URL, http://ip.jsontest.com returns the ip-address as a string in json-format.

Formula: =GetData("http://ip.jsontest.com")
with the following macro:

Function GetData(URL As String) As String
    Set OXH = CreateObject("msxml2.xmlhttp")
    With OXH
        .Open "get", URL, False
        .send
        x = .responseText
    End With
    Set OXH = Nothing
    GetData = x
End Function

for more json testurls, see: http://www.jsontest.com/#ip

[gutts009]

Hi, it very simple make you excel input TEXT only.
and use Opera to copy text from there it will not fetch link from website. and when you will past you will get the same thing.