+ Reply to Thread
Results 1 to 4 of 4

I need some help extracting data from a specified webpage

  1. #1
    Registered User
    Join Date
    07-01-2013
    Location
    Bogota, Colombia
    MS-Off Ver
    Excel 2010
    Posts
    13

    Unhappy I need some help extracting data from a specified webpage

    Hi! I have been trying to mak a code that allows me to extract some data from a webpage to output in a textbox. I have failed in all my attempts considering I really don't know how to call the specified segment from this webpage nor any other webpage, I was hoping somebody could help me, this is the page im trying to use to extract data: http://www.banrep.gov.co/es/series-estadisticas/see_ts_trm.htm Sadly it is in spanish, but I only need the currency value that is seen inside the page, which is actually the value of 1 dolar in COP (Colombian Pesos). I tryed to use a code from a youtube tutorial, achieving this code:

    Dim IE As New InternetExplorer
    IE.Visible = False
    IE.navigate "http://www.banrep.gov.co/es/series-estadisticas/see_ts_trm.htm"
    Dim Doc As HTMLDocument
    Set Doc = IE.document
    Dim sDD As String
    sDD = Doc.getElementsByTagName("strong").innerText

    I have made some analysis and the program succesfully starts the page if I write IE.Visible = True, I'm believeing im having issues with extracting data from the page. It would be awesome if someone could help me. Thanks alot

    I've attached an image so that you can see what's the data im trying to extract from a webpage
    Attached Images Attached Images

  2. #2
    Registered User
    Join Date
    07-18-2013
    Location
    aMSTERDAM
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: I need some help extracting data from a specified webpage

    The content is dynamicly loaded and is retrieved from a different URL over here:
    http://obiee.banrep.gov.co/analytics...es&options=rdf

    Im building an application that will be able to get html data out of websites, please email me at [email protected] if you are interested and I will send you an email back when the project is finished.

  3. #3
    Registered User
    Join Date
    07-01-2013
    Location
    Bogota, Colombia
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: I need some help extracting data from a specified webpage

    Thanks a lot for your help! So I changed the code in order to open that page, but I still can't manage to extract data from it, since I have no experience in HTML nor vba, I'm not sure what should I do. Could you help me adapting the code in order to extract the data I need (Specified through the image, but in the page you gave me). Thanks! About the application, I may be interested later on, but for now, It may be more interesting for me a program that allows me to send e-mails once I do something. Thanks again

  4. #4
    Registered User
    Join Date
    07-18-2013
    Location
    aMSTERDAM
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: I need some help extracting data from a specified webpage

    Try "table" or "div" instead of "strong" , thats all I can do...

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Load webpage on TOPMAN website, extract prices from webpage into Spreadsheet
    By AKK9 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-04-2013, 11:49 AM
  2. problem extracting data from webpage using getelementbyid
    By mwalshe99 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-11-2012, 08:57 AM
  3. Extracting Data from Webpage
    By Kevin.Antony in forum Excel General
    Replies: 4
    Last Post: 01-06-2012, 02:38 PM
  4. Extracting data from imported Webpage VBA
    By pnaquin in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-25-2011, 02:10 PM
  5. Extracting data from webpage
    By Gramzon in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-22-2009, 12:40 PM

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