none
Gibberish instead of Hebrew in VBA RRS feed

  • Question

  • HI,

    i created vba on my computer with hebrew fonts. when i try to run it on other computersm, on some of them it works good and in some (for ex. win8 + ofiice16)  i get runtime error 9 and the vba code is all gibberish (no hebrew) although there's hebrew on the excel.

    plz help me :)

    Sunday, November 26, 2017 5:54 PM

All replies

  • Please upload your file (maybe with anonymous data) on an online file hoster like www.dropbox.com and post the download link here.

    A macro to anonymize data in selected cells can be downloaded here:
    https://www.dropbox.com/s/rkfxuh85j5wyj9y/modAnonymize.bas?dl=1

    Andreas.

    Monday, November 27, 2017 4:25 PM
  • https://www.dropbox.com/s/phzg413hvte5m4v/%D7%A2%D7%95%D7%AA%D7%A7%20%D7%A9%D7%9C%20%D7%9E%D7%97%D7%A9%D7%91%D7%95%D7%9F%20%D7%9E%D7%A9%D7%9B%D7%A0%D7%AA%D7%90%20-%20%D7%96%D7%9E%D7%9F%20%D7%A0%D7%93%D7%9C%D7%9F_5.xlsm?dl=0

    Thanks Andreas

    Wednesday, November 29, 2017 11:30 AM
  • Okay, you have a problem.

    IMHO there is no easy way to make your file compatible with international PC's, you have to make some changes and rework your code.

    I've tried to post the detailed explanation and some instructions how to do the changes here, but the answer becomes so long, the forum did not let it me post it here directly.

    So here is a PDF file:
    https://www.dropbox.com/s/grc9otxokxcu2zy/82e7223f-a319-4096-ad2c-c6dbfcaddc9a.pdf?dl=1

    If anyone else has a different suggestion: I'm also interested.

    Andreas.

    Wednesday, November 29, 2017 7:48 PM