Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    May 2001
    Location
    MIA (takittodahous), Florida, USA
    Posts
    86
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Web Query (Office XP)

    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

  2. #2
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Trenton, Ontario
    Posts
    175
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Web Query (Office XP)

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

  3. #3
    Star Lounger
    Join Date
    May 2001
    Location
    MIA (takittodahous), Florida, USA
    Posts
    86
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Web Query (Office XP)

    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.

  4. #4
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Trenton, Ontario
    Posts
    175
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Web Query (Office XP)

    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?

  5. #5
    Star Lounger
    Join Date
    May 2001
    Location
    MIA (takittodahous), Florida, USA
    Posts
    86
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Web Query (Office XP)

    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!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •