Results 1 to 1 of 1

web query (external data) hangs 'orribly

Threaded View

  1. #1
    Registered User
    Join Date
    08-28-2011
    Location
    Victoria Australia
    MS-Off Ver
    Excel 2003
    Posts
    1

    web query (external data) hangs 'orribly

    I have created a web query on a sheetExcel 2003 Windows XP)
    With ActiveSheet.QueryTables.Add(Connection:=URLToday, Destination:=Range("A7"))
            .Name = "DisplayMeetings.aspx?State=1&DisplayType=TodaysRacing"
            .FieldNames = True
            .RowNumbers = False
    etc.....

    This works perfectly when called as part of macro routines but if I am silly enough to click on that sheet, the sheet becomes non responsive for several minutes and I may need to use the task manager to shut Excel down.

    I suspect it's sticking its nose up every link on the page (there are many)

    Is there a parameter on the list that I can alter to make it cease and just deal with what's visible?

    Is it this one (which is set to False?)
    .WebDisableRedirections = False
    Last edited by Leith Ross; 08-28-2011 at 08:27 PM. Reason: Added Code Tags

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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