Conflict between innertext date time and excel date time output

[MarceloPBG]

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!!

 

[wornhall]

Excel is converting the date string into an excel date, which is a serial number with a fraction. To keep the input date append a single quote to the front of the string:
dim opDate as String
opDate = "'" & yourScrapedDate

Some problems happen when an invalid date is input. You may need to handle these exceptions.


My experience of many years of date processing is that it is best to stay with the Excel date format. You may want to keep both formats in your output spreadsheets.