Improve company productivity with a Business Account.Sign Up

x
?
Solved

Pull data from web

Posted on 2016-10-07
2
Medium Priority
?
107 Views
Last Modified: 2016-11-07
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.
0
Comment
Question by:tonelm54
1 Comment
 
LVL 56

Accepted Solution

by:
Ryan Chong earned 2000 total points
ID: 41833778
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

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

If you need to implement application level security in an Access database application or other VBA code, I strongly encourage you to take advantage of Active Directory groups.
Here is why.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

579 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question