VBA Excel Internet Explorer capture table (td)

Asked

Viewed 457 times

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?

html

  • The content you will be looking for, the date is on TR or TD?

  • Oi Alexandre is inside the TD and inside the TD I have to click on href

  • What triggers the query in IE is a macro?

  • Already tried "Get external data" > "Web data" ?

  • 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

No answers

Browser other questions tagged html

You are not signed in. Login or sign up in order to post.