0
Not sure if what I am trying to accomplish is even possible but I figured I'd ask. I have a decent sized spreadsheet with specifications from hundreds of different smartphones that I am working on as sort of a pet project for myself and a tech forum I participate in. One of the columns I have is the "Fan Count" from GSMarena.com as a way of quantifying popularity and interest in the device. (the other two columns to the left are "PhoneArena Staff Rating" and "PhoneArena User Rating".)
For now, all I've been doing is entering the amount manually but that can get tedious with so many phones and with how often the number changes. What I'd like to know is if there is any way to automatically pull the "Fan Count" number from the source data of x phone's webpage?
Obviously, I wouldn't be able to have it search for each phone but if I can at at least put the source information for each phone in and have the numbers then update themselves, that would be sufficient.
Possible = yes. Difficult also = somewhat yes. You will need to use vba without a doubt but there are several methods out there that allow you to download a webpage by url and view the html form of it. Once you have the html, it is simply a matter if dissecting it to find your number – Eric F – 2015-11-12T19:19:46.043