Navigate a website with Excell Vba
        Posted  
        
            by Ommit
        on Stack Overflow
        
        See other posts from Stack Overflow
        
            or by Ommit
        
        
        
        Published on 2010-04-13T18:50:13Z
        Indexed on 
            2010/04/13
            18:53 UTC
        
        
        Read the original article
        Hit count: 239
        
excel-vba
I can pull data from known ulr, but can I navigate a website with excel.
For example can excel do a google search and put the results on a spreadsheet. Or navigate an in-frame site.
This code pulls data from a website.
With ActiveSheet.QueryTables.Add(Connection:= _
    PUT_URL_HERE, _
    Destination:=Range("A1"))
    .Name = "I need serious help"
    .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
    .WebDisableRedirections = False
    .Refresh BackgroundQuery:=False
End With
        © Stack Overflow or respective owner