+ Reply to Thread
Results 1 to 3 of 3

version office

Hybrid View

  1. #1
    Registered User
    Join Date
    03-16-2009
    Location
    italy
    MS-Off Ver
    Excel 2003
    Posts
    64

    version office

    i've got a macro in a vba sheet sometimes the sheet is used in a PC where there is a office 2007 in english and sometimes is use in a PC where there is a office 2007 in italian language , now i need to make some change in the code depending on the office's language installed can help me with some instruction that tell me the language office is installed
    Last edited by ilkamalo; 06-15-2010 at 03:50 AM.

  2. #2
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: version office

    msgbox     Application.LanguageSettings.LanguageID (msoLanguageIDUI)

  3. #3
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: version office

    For version:

    Application.Version
    For the active regional settings

    Application.International(xlCountrySetting)
    For insertion of formulae etc remember that VBA is US-centric by default so unless you're using FormulaLocal (as opposed to standard Formula) you should find you can code all of those parts in US form (incl. delimiters) without worrying about client settings (they will auto translate when written to the worksheet).
    (note: exceptions would be things like month denotations in TEXT function calls etc which would need to be adjusted)

    EDIT: the above point may not hold true on a non-English install - so apologies if misleading.
    Last edited by DonkeyOte; 06-14-2010 at 12:22 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1