Changing Regional Settings through VBA

  • Thread starter Thread starter Raul
  • Start date Start date
R

Raul

I would like to be able to change the regional settings
for short date format, long date format, and time format
using VBA in Excel. Any ideas or comments?

Thanks,
Raul
 
There are code examples out there using Kernel API.
Do a search for SetLocaleInfoA
 
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

Excel is changing date format incorrectly 7
Passing dates to Sql Server 2005 stored procedure 1
NumberFormat not getting changing onFly changing the regional sett 1
Setting a user's "Regional Options - Short Date" from Excel? 2
check date format in regional setting 2
Date Formats 3
How to get the available languages (MUI) of Excel using VBA? 0
Format an Excel Column in the window's short date format. 7

Back
Top