<div>
<div class="content wysiwyg-content">
Is it possible to get data from a website and return the value to a cell. The URL I have is &quot;<a href="http://test33.mylocalserver/?getVal=66" rel="ugc">http://test33.mylocalserver/?getVal=66</a>&quot;. If I go onto the websites URL I get 66, and I want to dump that value into a cell by using VBA.<br />
<br />
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.
</div>
</div>


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.

Pull data from web

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.