1
I need to capture in IE object <tr class="cab_table">
. Inside it, I have to search asking if part of the text contains the date 31072017
, and when finding this date on the same row have, click on href to download an excel file
<a title="Exporta Pdf" href="pesquisaAvisoPagamentoPdf.php?parametro_visualizacao=26902796" target="_blank">
<img width="15" src="/mercantil/pt_br/img/img_arq_pdf.gif" border="0">
</a>
How do I do that?
The content you will be looking for, the date is on TR or TD?
– Alexandre Cavaloti
Oi Alexandre is inside the TD and inside the TD I have to click on href
– Marcelo Sena
What triggers the query in IE is a macro?
– Alexandre Cavaloti
Already tried "Get external data" > "Web data" ?
– Alexandre Cavaloti
need to be in VBA because, the previous steps are in VBA... and need to search row by row if contains date 31072017, if positive click on href
– Marcelo Sena