troubleshooting Question

Pull data from web

Avatar of tonelm54
tonelm54 asked on
Microsoft ExcelVBA
1 Comment1 Solution142 ViewsLast Modified:
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.
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 1 Comment.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros