Results 1 to 1 of 1

Web Query Refresh Issue

Threaded View

  1. #1
    Registered User
    Join Date
    05-23-2007
    Location
    Singapore
    Posts
    1

    Web Query Refresh Issue

    Hi,

    I am not able to refresh the results of the webquery.
    Code:

    lstrWebAddress = "http://nse-india.com/marketinfo/fo/fomwatchsymbol.jsp?key="
    lstrStockcode = "ITC"
    lstrWebAddress = lstrWebAddress & lstrStockcode 
        ActiveWorkbook.Worksheets.Add
        With ActiveSheet.QueryTables.Add(Connection:= _
            lstrWebAddress, _
            Destination:=Range("A2"))
            .Name = "ITC"
            .FieldNames = True
            .RowNumbers = False
            .FillAdjacentFormulas = False
            .PreserveFormatting = True
            .RefreshOnFileOpen = False
            .BackgroundQuery = True
            .RefreshStyle = xlInsertDeleteCells
            .SavePassword = False
            .SaveData = True
            .AdjustColumnWidth = False
            .RefreshPeriod = 0
            .WebSelectionType = xlAllTables
            .WebFormatting = xlWebFormattingNone
            .WebPreFormattedTextToColumns = True
            .WebConsecutiveDelimitersAsOne = True
            .WebSingleBlockTextImport = False
            .WebDisableDateRecognition = False
            .Refresh BackgroundQuery:=False
        End With
    Once the web query downloads the data, successive "refresh" data thru right clicks does not refresh the actual data.

    If I go to the website thru IE and then perform the refresh operation, only then the data thru web query is refreshed.

    Is there something related to cache / temp IE files etc?

    How can I circumvent it?

    Cheers,
    Avinash
    Last edited by mudraker; 05-24-2007 at 02:23 AM.

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