Web Query (Office XP)

Topic

New Reply

Hi All,

I searched for 10 pages worth of listings (thread headings only…) and didn’t find anything – so here goes:

I have little (read: NO) experience in using this tool. It looks interesting. But I haven’t been able to get it to function the way I need it to. When I select the tables I want monitored and updated, the data returns blank. If there is a link within those sections, that pops up – but straight data on the page (text) doesn’t appear.

Can Excel ONLY keep track of links? If so, anyone have any tools that track changes in webpage content?

Thanks in advance for any help/advice!!!

Rok On, people

Reply | Quote

Replies

Can you give me the web page you’re trying to get the data from?

Reply | Quote

Sure – try http://www.miamiherald.com. The resulting link is a little different, but that should get you there. Thanks for taking a look! Your help is most appreciated.

Reply | Quote

Web Queries are meant to pull data off of a web page whenever you would like, for example, getting stock prices every 10 minutes. The problem is that the links aren’t data and therefore are not being downloaded into Excel. You can however set query to pull the entire page in HTML and it will pull the links as well but you won’t be able to see the information from the link until you click it.
What is it in particular are you trying to accomplish?

Reply | Quote

I’m actually trying to get the updated text off the page – not any links, in three specific spots, the Top Local, World and Local Sports story headline and available picture – I’m currently doing it manually, but I thought the query might take care of it – no such luck, I guess…

Thanks for your help!

Reply | Quote

I’m actually trying to get the updated text off the page – not any links, in three specific spots, the Top Local, World and Local Sports story headline and available picture – I’m currently doing it manually, but I thought the query might take care of it – no such luck, I guess…

Thanks for your help!

Reply | Quote

Web Queries are meant to pull data off of a web page whenever you would like, for example, getting stock prices every 10 minutes. The problem is that the links aren’t data and therefore are not being downloaded into Excel. You can however set query to pull the entire page in HTML and it will pull the links as well but you won’t be able to see the information from the link until you click it.
What is it in particular are you trying to accomplish?

Reply | Quote

Sure – try http://www.miamiherald.com. The resulting link is a little different, but that should get you there. Thanks for taking a look! Your help is most appreciated.

Reply | Quote

Can you give me the web page you’re trying to get the data from?

Reply | Quote