Browse 545 attributed reviews, viewable separately for our classroom and online training

Details for SantosEloy

SantosEloy has participated in the following threads:

Added by SantosEloy on 08 May 2019 at 15:18

Hi Andrew,

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

https://www.cenace.gob.mx/SIM/VISTA/REPORTES/PreEnergiaSisMEM.aspx

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

Hi Andrew,

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

https://www.cenace.gob.mx/SIM/VISTA/REPORTES/PreEnergiaSisMEM.aspx

This is the code I'm analysing:

Sub Downloadparamostrarproblema()
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
End With
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)
HTMLspan.Click
Set Pepe = HTMLdoc.getElementById("ctl00_ContentPlaceHolder1_ListViewNodos_ctrl0_ListViewArchivosSIN_ctrl0_linkCSV")
Pepe.Click
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?

Regards, Santos.

Added by SantosEloy on 12 Aug 2021 at 09:31

Hi Andrew

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

https://memsim.cenace.gob.mx/Produccion/Participantes/LOGIN/

I'm trying to upload a file, but i am unable to select the button

I try with 

    Set CH = New Selenium.ChromeDriver
    
    CH.Start
    
    CH.Get "https://memsim.cenace.gob.mx/Produccion/Participantes/LOGIN/"

    CH.FindElementById("uploadCerfile0").Click

And the excel gives a mistake

Selenium Error

invalid argument

(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)