How to change with VBA Regional setings

  • Thread starter Thread starter niki
  • Start date Start date
Are you sure you want to do this? Regional Settings are chosen by the users,
and we, as developers, should not feel that we have the right to overrule
their choices. I know that if someone messed with my settings, I would
quickly scrap the application.

If you're determined to do this, you should be able to use the SetLocaleInfo
API call.

Randy Birch has a sample of using this API to change date formats at
http://vbnet.mvps.org/code/locale/setlocaleinfo.htm You should be able to
modify that code to use the constant LOCALE_SDECIMAL rather than
LOCALE_SLONGDATE or LOCALE_SSHORTDATE as he is.

The declaration for LOCALE_SDECIMAL would be:

Public Const LOCALE_SDECIMAL As Long = &HE
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I solve problem with AciveX component or OLE Server? 1
Modeling Question: Country | Region | Sub-Region 3
Comma as a decimal symbol (Regional and Language settings) 1
How to convert Decimal number with comma(,) as decimal separator to dot(.) 1
How to convert Decimal number with comma(,) as decimal separator to dot(.) 5
Comma as a decimal symbol 2
vba macro that allows insertion of symbols at cursor 0
Problem with switch between EN and BG Keyboard 2

Back
Top