Results 1 to 1 of 1

want to pull in data from multiple web pages

Threaded View

arcam2004 want to pull in data from... 07-17-2012, 08:01 PM
  1. #1
    Registered User
    Join Date
    07-17-2012
    Location
    london, england
    MS-Off Ver
    Excel 2010
    Posts
    1

    Cool want to pull in data from multiple web pages

    want to pull in data from multiple pages from website http://uk.webuy.com/product.php?mode=buy&catid=830

    i can only get 1 page to load in excell 2010 but want all pages my code is,

    Sub Macro1()
    '
    ' Macro1 Macro
    '
    
    '
        With ActiveSheet.QueryTables.Add(Connection:= _
            "URL;http://uk.webuy.com/product.php?mode=buy&catid=830", Destination:=Range( _
            "$A$1"))
            .Name = "product.php?page=52&catid=808"
            .FieldNames = True
            .RowNumbers = False
            .FillAdjacentFormulas = False
            .PreserveFormatting = True
            .RefreshOnFileOpen = False
            .BackgroundQuery = True
            .RefreshStyle = xlInsertDeleteCells
            .SavePassword = False
            .SaveData = True
            .AdjustColumnWidth = True
            .RefreshPeriod = 0
            .WebSelectionType = xlSpecifiedTables
            .WebFormatting = xlWebFormattingNone
            .WebTables = "3"
            .WebPreFormattedTextToColumns = True
            .WebConsecutiveDelimitersAsOne = True
            .WebSingleBlockTextImport = False
            .WebDisableDateRecognition = False
            .WebDisableRedirections = False
            .Refresh BackgroundQuery:=False
        End With
    End Sub

    Hope someone can help, as im new to all of this
    Last edited by JBeaucaire; 07-17-2012 at 08:47 PM. Reason: Added code tags, as per forum rules. Don't forget!

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