HOW TO CHANGE REGIONAL SETTINGS

[Neovecchi]

Hi There,

In our company we would like to have all the same regional settings set for a department to dutch and a other department to US. Now when we have built an application in excel, we are having problems with the date and time format because it is on every computer set on UK, when we want the settings to be set to european format (dutch, german etc).

Can somebody give me a code for a script that we can run to change the computers regional settings. It has to work with winxp, but should not be done for the entire company just for that single computer so no one else will encounter problems.

I will be very greatful if somebody could help me out.

Thanks in advance,

Neovecchi

 

[ClayG]

The settings are the Registry:

[HKEY_CURRENT_USER\Control Panel\International]

Use WshShell.RegRead and RegWrite.

Disclaimer: writing to the windows registry can disable your PC if you get it wrong.

IF! you go ahead, at least write the Reg values that are being overwritten to some kind of file in a shared location, so that if it goes wrong, you know what to set the values back to. Find out about recovering from Registry corruption.