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.