VBA-PROBLEM: DATEs AND HOURs SETTING

[mimmoquadro]

Sometime I’m loading dates/hours from web sites and the loaded data are not correctly understood by Excel 2003 (my version) due to their separator setting (e.g. hours separator “:” rather than “.” and viceversa -> like 23:30:15 instead of 23.30.15).

What I'm looking for is to fix a VBA SUB to modify the actual set of “International Options and Languages” of Office to another, in order to change the format of value, dates and hours before loading web data in the excel file where the macro is running.

I have tested the following SUB without results:

Sub International_option ()

Shell "control.exe intl.cpl", 1 ‘activate International form
SendKeys "{DOWN 8}", True ‘eight position down to move from English (GB) to Italian
SendKeys "{TAB 3}", True
SendKeys "{ENTER}", True ‘this instruction is not effective

End Sub

The above SUB is able to display the International Option and Languages form, to scroll the languages from English (GB) to Italian (IT), to select the OK button but …… unfortunately the final ENTER command is not effective (e.g. the hours are still separated by : as per English instead of . as per Italian language)

Its seams that only a manual activation of OK button is effective, if the ENTER command (the last one in my example of SUB) is removed from the macro.

Any help is highly appreciated.

Thanks a lot

Mimmo

[pike]

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.