+ Reply to Thread
Results 1 to 5 of 5

My language letters become to hieroglyphs in VBA. Need help.

Hybrid View

  1. #1
    Registered User
    Join Date
    02-09-2015
    Location
    Mazeikiai, Lithuania
    MS-Off Ver
    2007
    Posts
    18

    My language letters become to hieroglyphs in VBA. Need help.

    Hi,
    I have huge problem. I have workbook with vba codes with links to workbooks which consist of letters in my language ( š ę ė etc...)
    And when I gave this workbook to my colleague, all my language letters (like š ę ė etc...) became to hieroglyph
    Can anyone help for me?
    Thank you all, and sorry for my english..

  2. #2
    Registered User
    Join Date
    02-09-2015
    Location
    Mazeikiai, Lithuania
    MS-Off Ver
    2007
    Posts
    18

    Re: My language letters become to hieroglyphs in VBA. Need help.

    Nobody can help me?

  3. #3
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,053

    Re: My language letters become to hieroglyphs in VBA. Need help.

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    Never use Merged Cells in Excel

  4. #4
    Registered User
    Join Date
    02-09-2015
    Location
    Mazeikiai, Lithuania
    MS-Off Ver
    2007
    Posts
    18

    Re: My language letters become to hieroglyphs in VBA. Need help.

    Sorry for my missunderstanding. I ll copy codes before and after.
    Private Sub CommandButton2_Click()
    On Error GoTo Klaida
    Workbooks.Open Filename:="\\linktoworkbook\Žaliavų sąrašas\zaliavos.xlsm"
    Workbooks("zaliavos.xlsm").Sheets("mdp").Activate
    Exit Sub
    Klaida:
    MsgBox ("Lentelė atidaryta"), vbExclamation, "Klaida"
    End Sub
    This code is good, but when I send it to my colleague, code becomes:

    Private Sub CommandButton2_Click()
    On Error GoTo Klaida
    Workbooks.Open Filename:="\\\linktoworkbook\Þaliavø sàraðas\zaliavos.xlsm"
    Workbooks("zaliavos.xlsm").Sheets("mdp").Activate
    Exit Sub
    Klaida:
    MsgBox ("Lentelë atidaryta"), vbExclamation, "Klaida"
    End Sub
    I start to think, that our language is not installed into my colleague computer, and thats the problem.

  5. #5
    Forum Contributor
    Join Date
    08-04-2014
    Location
    Riga
    MS-Off Ver
    2010
    Posts
    579

    Re: My language letters become to hieroglyphs in VBA. Need help.

    I start to think, that our language is not installed into my colleague computer, and thats the problem.
    I was going to suggest this. Check for language/font compatibility on both PC's.

    Good luck, neighbor

    P.S.
    To avoid these problems avoid using special characters in file or folder names, if possible. Instead of š, ž, č, ē, ū, ļ, ķ, just use s, z, c, e, u, l, k.
    Last edited by bmouse; 02-23-2015 at 06:42 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Change Button language according to Language Settings
    By Meithom in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-02-2015, 05:00 AM
  2. Remove English language text in excel and retain foreign language.
    By prakaz in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-05-2014, 02:05 PM
  3. Real time text translation to match the language selectedin language vailidation
    By Rocky2013 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-01-2013, 09:23 PM
  4. Replies: 5
    Last Post: 08-16-2010, 02:46 PM
  5. language support in excel sheet using a third party language tool
    By seema in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-13-2006, 02:10 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