Details for SantosEloySantosEloy has participated in the following threads:
Added by SantosEloy on 08 May 2019 at 15:18
First of all, thank you very much for your videos, I've learnt a lot with them.
I have a problem with this web page
I'm able to web thorught the web, but I can't make click on the checkbox which is near the text "Precios de la Energia". With you videos I was able to change the status of the checkbox from rtUnchecked to rtChecked, but the result is very different than when I click on the web ..
I think when I click on the web page some code is executed, but I can see how to do it ...
Added by SantosEloy on 14 May 2019 at 11:47
Great video and great explanation'
I have a problem to download a file form a web page, may be you can help me' The problem is that there is no link to use the URLDownloadToFile Function. All I have is an event.click .... this is not the original website, but I can explain myself
This is the code I'm analysing:
Dim IE As InternetExplorer
Dim HTMLdoc As HTMLDocument
Dim URL As String
Dim Pepe As Object
URL = "https://www.cenace.gob.mx/SIM/VISTA/REPORTES/PreEnergiaSisMEM.aspx"
Set IE = CreateObject("InternetExplorer.Application")
With IE .navigate URL
Do Until .readyState = 4: DoEvents: Loop
IE.Visible = True
Set HTMLdoc = IE.document
Dim HTMLdiv As HTMLDivElement
Set HTMLdiv = HTMLdoc.getElementById("ctl00_ContentPlaceHolder1_treePrincipal")
Dim HTMLspan As HTMLSpanElement
Set HTMLspan = HTMLdiv.getElementsByTagName("span").Item(2)
Set Pepe = HTMLdoc.getElementById("ctl00_ContentPlaceHolder1_ListViewNodos_ctrl0_ListViewArchivosSIN_ctrl0_linkCSV")
Set HTMLdiv = Nothing
Set HTMLdoc = Nothing
Set IE = Nothing End Sub
I know that in this case I have a Href I could use to download the file, but in the web page I'm working on it has NO link, and I want to download automatically the file.
Any idea how to download pepe.click automatically?
Added by SantosEloy on 12 Aug 2021 at 09:31
First of all I want to give THANKS for your videos, I have learnt a lot about web scrapping.
I have tried lots of attemps with this web page, but no way to make it work ... may be you can help me
I'm trying to upload a file, but i am unable to select the button
I try with
Set CH = New Selenium.ChromeDriver
And the excel gives a mistake
(session info: chrome 92.0.4515.131)
(Driver info: chromedriver=91.0.4472.101
(af52a90bf87030dd1523486a1cd3ae25c5d76c9b-refs/branch-heads/4 NT 10.0.19043 x84_64)