Hello,
I am beginner with extracting data via VBA from webpages, and still I could not find a solution to this :
my code gets all the values that I need except for this one :
<div class="value"><img src="/images/text.php?type=empresa&field=telefone&id_empresa=289251"></div>
Any thoughts ?
I am beginner with extracting data via VBA from webpages, and still I could not find a solution to this :
my code gets all the values that I need except for this one :
<div class="value"><img src="/images/text.php?type=empresa&field=telefone&id_empresa=289251"></div>
Code:
Dim ie As Object ' InternetExplorer
Dim HTML As HTMLDocument
' All elements
Dim elc As HTMLHtmlElement
Set ie = CreateObject("InternetExplorer.Application")
ie.navigate "https://portalnacional.com.pt/empresa/florensis-portugal-producao-floricola-sociedade-unipessoal-lda-289251/"
Set HTML = ie.Document
For Each elc In HTML.getElementsByClassName("value")
Debug.Print elc.innerText
Next
Any thoughts ?