Pull data from web

Is it possible to get data from a website and return the value to a cell. The URL I have is "http://test33.mylocalserver/?getVal=66". If I go onto the websites URL I get 66, and I want to dump that value into a cell by using VBA.

Ive had a look around and people say using a webtable, but as its only 1 value for 1 cell I dont want to keep setting up a webtable as there are lot of cells pulling different values depending on values of other cells.
tonelm54Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Ryan ChongConnect With a Mentor Commented:
basically, you can use the Excel's existing wizard to grab a web page content. check this out for further details.

Get external data from a Web page
https://support.office.com/en-us/article/Get-external-data-from-a-Web-page-708f2249-9569-4ff9-a8a4-7ee5f1b1cfba?ui=en-US&rs=en-US&ad=US&fromAR=1

or you can try use a XMLHTTP request (or similar) in VBA environment, and after calling the method, try to grab the response text. Finally, we need to parse the response text and put into the format you wanted in Excel.
0
All Courses

From novice to tech pro — start learning today.