Questa è la macro
- Codice: Seleziona tutto
Public IE As Object
Sub NAVIGA()
myURL = "https://www.PIPPO.it/lr/home"
If Sheets("GERARCHIA").Range("H3").Value = "" Then
Exit Sub
Else
If Sheets("GERARCHIA").Range("H2").Value = "" Then
Exit Sub
End If
'
If IE Is Nothing Then Set IE = CreateObject("InternetExplorer.Application")
'
With IE
.Navigate myURL
.Visible = True
Do While .Busy: DoEvents: Loop 'Attesa not busy
Do While .ReadyState <> 4: DoEvents: Loop
End With
myLogin = Sheets("Firme").Range("D1").Value
myPassw = Sheets("GERARCHIA").Range("H3").Value
'
IE.document.all("username").Value = myLogin
IE.document.all("password").Value = myPassw
Set myColl = IE.document.getElementsByClassName("button-wrap")
myColl(0).getElementsByTagName("button")(0).Click
Do While IE.Busy: DoEvents: Loop 'Attesa not busy
'Do While IE.ReadyState <> 4: DoEvents: Loop 'Attesa documento
IE.Navigate Sheets("Firme").Range("F1").Value
‘E DOPO C’E’ “ESTRAI GRIGLIA”
Set IE = Nothing
End If
End Sub
Questo è il primo tag iFrame immediatamente successivo
- Codice: Seleziona tutto
<td height="100%" id="reportIFrame" valign="top">
<iframe name="report" width="100%" height="100%" id="report" src="/lr/rdv-fe-lr-proxy-portlet/default.rdvproxy_WAR_rdvfelrproxyportlet_INSTANCE_WwNO9epqJDMA/wfemlayout/wlt/blankPage.html" frameborder="0" scrolling="auto"></iframe>
</td>