VBA - Separators setting for web loading data

[mimmoquadro]

Hello Excel Forum

A set of data loaded from web appear to be uncorrect when the separator setting of values, dates and hours (e.g. ":") is related to the italian selection of the "International Options and Languages".

Please refer to the attached file LOADING_IT.xls for an example.

In case English related separators set is selected the data are correctly loaded from the web. Refer to the attached file LOADING2.xls.

Is there a potential VBA macro to be run before or after the above mentioned web data loading to avoid my problem?.

Thanks a lot for any suggestion

Bye bye

Mimmo