0

I have a some question. I want to parsing XML realtime data some website.

I'm using below Function.

Function GetHTML(URL As String) As String

Dim HTML As String
With CreateObject("MSXML2.XMLHTTP")
    .Open "GET", URL, False
    .Send
    GetHTML = .ResponseText
End With

End Function

But, It doesn't respond recent(=renewed data) data. Just, first request data are holding.

How Could I get recent data from website?

Improve this question
3
Related questions
3
Parsing XML in VBA
1
Query and parse xml attribute value into XLS using VBA
1
Parse Data in XML Document to Excel Worksheet
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.