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
Bookmarks