Excel VBA Local name of months and days from Windows regional settings

If you need to produce or list names of months or days from VBA, VBA will only do this in the US English language. However, you can code VBA to read from Windows regional settings, so that you can produce names of months and days in user's local language. The VBA code reads the settings from Windows regional settings, and applies the local names of months and days in the VBA output. Code includes settings for both 32-bit and 64-bit Excel.

This workbook shows the complete VBA/macro code to make this happen.

You get full access to the complete VBA/macrocode. The code is set up as function in the workbook, so it is available in the spreadsheet as formula. However, it is easy to implement the code in your own Excel application, as the code is short, neat and clean. All codes are open and visible, without any password protections.

Promotional video on YouTube: https://www.youtube.com/watch?v=CIroecWUkKY

The code is free to use in your own applications. However, you may not copy the file or codes to give to others, and you may not publish communicate the workbook or code digitally or in any other form, on Internet or elsewhere.

When code is implemented in your own application, you may of course distribute you application, paid or unpaid, with code inside your application.