Can you change the windows regional settings to Australian with a macro?

[dpaton05]

Is it possible to change the regional settings in windows to Australian with a macro? I need to know as I can build that into my spreadsheet as the users might not know how to change it manually.

 

[James006]

Hello,

With Excel .. when a question is asked : is it feasible or not ? ... the Answer is always Yes it is possible ...

But, sometimes, this involves relatively tricky solutions ... especially when it comes to manipulating the Windows configuration of others ....

Why don't you ... more simply ...write a procedure for your Users ...?

 

[dpaton05]

Do you mean just write instructions for the user?

 

[MARK858]

If they don't know how to change their regional settings for your spreadsheet how are they supposed to change it back to their settings afterwards?
Personally I wouldn't want anyone playing with my regional settings.

Do you mean just write instructions for the user?

James006 probably means exactly that.

 

[James006]

Do you mean just write instructions for the user?

Yes exactly ...

 

[James006]

Forgot to mention

By the way, if your question is only related to Date Format ...

Within VBA, using DateSerial would allow you to bypass the hurdle ...

Hope this will help