+ Reply to Thread
Results 1 to 3 of 3

Reference Website

  1. #1
    Registered User
    Join Date
    06-13-2007
    Posts
    9

    Reference Website

    Is there a way to reference data on an external website? I would like my spreadsheet to update frequently with the most current data provided by the external web host.

    Thanks.

  2. #2
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Does this link help

    http://office.microsoft.com/en-us/ex...450851033.aspx

    VBA Noob
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!

  3. #3
    Registered User
    Join Date
    06-13-2007
    Posts
    9
    The link helped and we are up and running! Thank you.

    I have it set to update every time the workbook is opened, I know for a fact that the online data has not changed yet, so when I open the workbook up, I receive this message:

    "The web query returned no data. To change the query, click ok, click the arrow on the name box in the formula bar, click the name of the external data range for the web query, right click the selection, and then click edit query"

    Am I receiving this message because the external data has remained the same as the previously imported data? I'm assuming when the online data is modified, I will no longer get this message. Are my assumptions correct?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1