How to change Language setting with Excel VBA

[FareedKhan]

Hi All,

I am using a macro in excel 2003, before running the macro I need to change the language setting to German(Germany) in control panel -> regional and language options.

Could anybody help me in doing the language setting via Excel VBA.


Thanks
Fareed

 

[Andrew Poulsom]

Why do you need to do that?

 

[FareedKhan]

I dont know, but it is required to do the settings for one of my reports.
Is there any way to do that?

Thanks
FK

 

[Andrew Poulsom]

You can use the Windows API. You should find the code you need on Google.