Hi,
I'm trying to read websites through excel. What I basically want to do is have the information on the web-page displayed in my excel spreadsheet, hopefully with an auto update eventually. Is this possible?
Thanks in advance,
Phil
Hi,
I'm trying to read websites through excel. What I basically want to do is have the information on the web-page displayed in my excel spreadsheet, hopefully with an auto update eventually. Is this possible?
Thanks in advance,
Phil
Hello Phil,
You should investigate using a Query to automatically bring in data from a website to your worksheet. On the main menu...
Data > Import External Data > New Web Query...
Sincerely,
Leith Ross
Thanks! That's not quite working the way I wanted, what I really need to do is actually covert the web pages into excel sheets if it's possible so that the data can be extracted more easily.
Thanks again,
Phil
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks