MarceloPBG
New Member
- Joined
- Apr 4, 2017
- Messages
- 1
Hello,
I need help scraping information from InternetExplorer to an Excel Workbook .
When i scrap, information in the innertext property is correct, but in the excel it comes wrong.
Using the code:
Workbooks("Automatizar PSA").Sheets(1).Cells(linha, 5).Value =
ie.Document.getelementsbyclassname("tr-visualizar-detalhes text-center")(i + 1).innertext
I think this is caused because they assume diferent variables, i used variable inspection and got:
Watch : : ie.Document.getelementsbyclassname("tr-visualizar-detalhes text-center")(i + 1).innertext :
"06/04/2017 11:09 " : Variant/String : Módulo11.PSAScrap
Watch : : Workbooks("Automatizar PSA").Sheets(1).Cells(linha, 5).Value :
04/06/2017 11:09:00 : Variant/Date : Módulo11.PSAScrap
Any help, how can i fix that? Sorry for the way i posted, not familiar with forums, how can i paste it as code?
Thank you!!
I need help scraping information from InternetExplorer to an Excel Workbook .
When i scrap, information in the innertext property is correct, but in the excel it comes wrong.
Using the code:
Workbooks("Automatizar PSA").Sheets(1).Cells(linha, 5).Value =
ie.Document.getelementsbyclassname("tr-visualizar-detalhes text-center")(i + 1).innertext
I think this is caused because they assume diferent variables, i used variable inspection and got:
Watch : : ie.Document.getelementsbyclassname("tr-visualizar-detalhes text-center")(i + 1).innertext :
"06/04/2017 11:09 " : Variant/String : Módulo11.PSAScrap
Watch : : Workbooks("Automatizar PSA").Sheets(1).Cells(linha, 5).Value :
04/06/2017 11:09:00 : Variant/Date : Módulo11.PSAScrap
Any help, how can i fix that? Sorry for the way i posted, not familiar with forums, how can i paste it as code?
Thank you!!