Results 1 to 2 of 2

how to gain access to excel controls in english and other language version.

Threaded View

  1. #1
    Registered User
    Join Date
    03-25-2013
    Location
    Italy
    MS-Off Ver
    Excel 2003
    Posts
    1

    how to gain access to excel controls in english and other language version.

    Hello,
    maybe I have to study better vba programming but I'm not able to solve this problem by myself.
    I created the code that should activate the "rectangle" function of the commandbar "drawing". This is the code line that works well:

    Application.CommandBars("Drawing").Controls("Rectangle").Execute
    but, if I copy the code in a pc with excel in a language other than english the code doesn't work (in my case the language is italian). This is because the italian name of the control rectangle is "rettangolo". I thought to solve the problem by using the ID of the control (for the commandbar "drawing" and the control rectangle is 1111) so the code would work both in the english and italian version. But I was wrong.

    Application.CommandBars("Drawing").Controls(1111).Execute
    Where I'm wrong? I need to write the code that works in the two versions of excel...
    Thanks in advance to those who wants to help me.
    Last edited by alansidman; 10-27-2013 at 06:40 PM. Reason: Code tags added in accordance with Rule #3

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Access data is showing in different symbols unable to change the language to english
    By devraj.kgp in forum Access Programming / VBA / Macros
    Replies: 0
    Last Post: 11-14-2011, 05:40 AM
  2. Covert the text in the Excel from English to other language
    By abiram01 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-22-2009, 10:00 AM
  3. Windows version language and Excel version language
    By Jac Tremblay in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-01-2006, 11:10 AM
  4. Replies: 0
    Last Post: 05-02-2006, 07:55 PM
  5. Replies: 1
    Last Post: 08-23-2005, 11:05 AM

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