VBA: download from an external source and date format

[Nelson78]

Hello everybody.

I'm stuck in the following situation.
I'm downloading data from an external source.
As you can see in the image, some of the dates are not correct: exactly, the ones in right alignement, written in letters.

For example, "martedì 4 gennaio 2022" is uncorrect: the correct date is "1 aprile 2022". So, in italian, it is not 04/01/2022 but it should be "01/04/2022".

Is there a way to regularize the download?

Thanks in advance.

Nelson

 

[Kerryx]

what are you downloading from is it a webpage are you using anything like power query?

 

[Nelson78]

I get data from a webpage ending with .aspx
simply navigating this way:

Set IE = CreateObject("InternetExplorer.Application")

With IE
    .navigate myURL
    .Visible = True
    Do While .Busy: DoEvents: Loop    
    Do While .readystate <> 4: DoEvents: Loop 
End With

 

[Kerryx]

Think you may get an answer here https://stackoverflow.com/questions/15959008/import-web-data-in-excel-using-vba