Results 1 to 3 of 3

Web Query and Page Source - Importing Data

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-09-2011
    Location
    Nomans, Land
    MS-Off Ver
    Excel 2007
    Posts
    103

    Web Query and Page Source - Importing Data

    Hi,

    Im trying to import a table from this URL: [url]http://www.bmfbovespa.com.br/cias-listadas/titulos-negociaveis/BuscaTitulosNegociaveis.aspx?Idioma=en-us[url]http://www.excelforum.com/excel-programming/

    Stocks Traded Table...

    However, it returns blank.. I looked at the page source (attached) and found the table inside! But, how am I going to manage pasting this table on excel using vba??

    Rgds

    Function WebQry(wbURL As String, wbTab As String, wbRng As String)
    With ActiveSheet.QueryTables.Add(Connection:= _
    (wbURL), Destination:=Range(wbRng)) 'wbURL / wbRng
                .WebTables = wbTab 'wbTab
                .WebSelectionType = xlSpecifiedTables
                .WebFormatting = xlWebFormattingNone
                .WebPreFormattedTextToColumns = True
                .WebConsecutiveDelimitersAsOne = True
                .WebSingleBlockTextImport = False
                .WebDisableDateRecognition = False
                .WebDisableRedirections = False
                .Refresh BackgroundQuery:=False
                .FieldNames = True
                .RowNumbers = False
                .FillAdjacentFormulas = False
                .PreserveFormatting = True
                .RefreshOnFileOpen = False
                .BackgroundQuery = True
                .AdjustColumnWidth = True
                .RefreshPeriod = 0
                .SaveData = False
    End With
    Attached Images Attached Images
    Last edited by exc4libur; 03-28-2011 at 02:19 PM.

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