Windows version language and Excel version language
Hi,
I would like to know how to find out if the user's workstation is configured with Windows XP English or French (and possibly Spanish). The same with the Excel version that is installed. I read a lot about Environ, but that information is not there. In the registry, what do i look for? For Excel, I can always check if the "File" menu exists. If yes, then Excel is in English. If not, check if "Fichier" exists. If yes, then Excel is in French and otherwise, in another language. But that method is not very "professional" to me. So would anyone know where I could find that information? Note: we all use Windows XP Professional and Excel XP (2002). Thank you. -- Jac Tremblay |
Windows version language and Excel version language
Hi Jac,
Try: Application.international(xlCountryCode) Application.international(xlCountrySetting) --- Regards, Norman "Jac Tremblay" wrote in message ... Hi, I would like to know how to find out if the user's workstation is configured with Windows XP English or French (and possibly Spanish). The same with the Excel version that is installed. I read a lot about Environ, but that information is not there. In the registry, what do i look for? For Excel, I can always check if the "File" menu exists. If yes, then Excel is in English. If not, check if "Fichier" exists. If yes, then Excel is in French and otherwise, in another language. But that method is not very "professional" to me. So would anyone know where I could find that information? Note: we all use Windows XP Professional and Excel XP (2002). Thank you. -- Jac Tremblay |
Windows version language and Excel version language
Hi Norman,
I tried that code: Sub ApplicationSettings() Dim strMsg As String strMsg = "xlCountryCode = " & Application.International(xlCountryCode) & _ vbCrLf & "xlCountrySetting = " & Application.International(xlCountrySetting) MsgBox strMsg End Sub I get 33 and 2 (French Canada settings for Excel). Where can I get the list of the different settings and other informations available? And what about the windows installation (French, English or other)? Thanks for your comment. -- Jac Tremblay "Norman Jones" wrote: Hi Jac, Try: Application.international(xlCountryCode) Application.international(xlCountrySetting) --- Regards, Norman "Jac Tremblay" wrote in message ... Hi, I would like to know how to find out if the user's workstation is configured with Windows XP English or French (and possibly Spanish). The same with the Excel version that is installed. I read a lot about Environ, but that information is not there. In the registry, what do i look for? For Excel, I can always check if the "File" menu exists. If yes, then Excel is in English. If not, check if "Fichier" exists. If yes, then Excel is in French and otherwise, in another language. But that method is not very "professional" to me. So would anyone know where I could find that information? Note: we all use Windows XP Professional and Excel XP (2002). Thank you. -- Jac Tremblay |
Windows version language and Excel version language
Hi Jac,
See: http://www.studyabroad.com/telcodes.html Or, use your telephone directory's international pages. --- Regards, Norman "Jac Tremblay" wrote in message ... Hi Norman, I tried that code: Sub ApplicationSettings() Dim strMsg As String strMsg = "xlCountryCode = " & Application.International(xlCountryCode) & _ vbCrLf & "xlCountrySetting = " & Application.International(xlCountrySetting) MsgBox strMsg End Sub I get 33 and 2 (French Canada settings for Excel). Where can I get the list of the different settings and other informations available? And what about the windows installation (French, English or other)? Thanks for your comment. -- Jac Tremblay "Norman Jones" wrote: Hi Jac, Try: Application.international(xlCountryCode) Application.international(xlCountrySetting) --- Regards, Norman "Jac Tremblay" wrote in message ... Hi, I would like to know how to find out if the user's workstation is configured with Windows XP English or French (and possibly Spanish). The same with the Excel version that is installed. I read a lot about Environ, but that information is not there. In the registry, what do i look for? For Excel, I can always check if the "File" menu exists. If yes, then Excel is in English. If not, check if "Fichier" exists. If yes, then Excel is in French and otherwise, in another language. But that method is not very "professional" to me. So would anyone know where I could find that information? Note: we all use Windows XP Professional and Excel XP (2002). Thank you. -- Jac Tremblay |
All times are GMT +1. The time now is 04:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com