VBA‎ > ‎

Collecting Application.International settings

Thank you for visiting E90E50!


The aim of our project is to collect and publish the list of regional settings used in different language Excel versions. Some of these settings come from Windows, others are defaults of Excel, so we need the help of users who can send us their "real world" settings.
We believe this collection could be a great help for those developing international applications in Excel.

This small Excel VBA will capture what is needed:

Sub test_Excel_Application_International()
    Dim i As Long
    ActiveSheet.Columns(1).EntireColumn.Insert
    Cells(1, 1) = "'" & Application.Version
    For i = 1 To 45
        Cells(i + 1, 1) = Application.International(i)
    Next
End Sub

You can see it reads only the values of application.international and writes it to column A. No personal information will be collected.

Please open the attached file. (You can find at the bottom of this page too, download by clicking on the arrow.)
After enabling macros you only need to push start button.
The macro will only read informations from your Excel and write it to the sheet. It will take only 1 second. If you would like your name to be published for your contribution, please write it to the sheet.

Do you have different Excel versions (2000, 2002, 2003, 2007, 2010, 2013)? It would be the great if you could run this macro in all versions one by one (you could use the same file)!

If you have the result, please save the file and send it back to us - you can find the e-mail address in the file. (You can copy the result to a new file if you insist to save the original - we only need the result of the test, nothing else.)


Take a look at this shared file to follow what we have already and what language/Excel version combinations are missing:
Collection

We also collect screenshots about different language Excels - we will be happy if you could send one about your language! :-)

Please share with your friends - maybe they have the missng versions!

Many thanks for your help!


Update:

>We would like to say special thanks to Daniel Ferry who posted on his blog about our mission:

Regional Excel Differences - Leave Your Marks---leave-your-mark

>And special thanks to Jamie Bull too, for posting about us and appreciating this site:

Regional settings in Excel – research

>Uno speciale grazie anche a Maurizio

>We are grateful to Mynda Tracey, owner of myOnlineTraininghub for writing about our project:

http://www.myonlinetraininghub.com/excel-same-same-but-different

>And we are saying a huge thank you to Debra Dalgleish owner of Contextures.com for sharing our project in her newsletter.


>You can add your comments to the discussion on LinkedIn:

http://lnkd.in/Pqhn64



Č
Ĉ
Krisztina Szabó,
Dec 31, 2012, 8:43 AM
Comments

Bibliografia essenziale