none
How to insert Japanese character to SAP from Excel? RRS feed

  • Question

  • Hi All,
    Help needed in an issue in Excel VBA.

    I can see the Japanese text in the excel cells. Exporting this data to SAP by using VBA code. It does the insert in the ECC, but Japanese characters are represented as "????"
    The Japanese string - れは、のテストです excel シート アップロード テンプレート

    the above string is displaying as - ???SES ?????? excel ??? ?????? ??????

    I am using the below code cv=Sheet1.Range("A1").Value
    i tried by using cv = StrConv(Sheet1.Range("A1").Value, vbUnicode)

    Any help would be appreciated.

    rafee

    Tuesday, February 12, 2013 3:48 AM

All replies

  • Hi All,
    Help needed in an issue in Excel VBA.

    I can see the Japanese text in the excel cells. Exporting this data to SAP by using VBA code. It does the insert in the ECC, but Japanese characters are represented as "????"
    The Japanese string - excel シート アップロード テンプレート

    the above string is displaying as - excel ??? ?????? ??????

    I am using the below code cv=Sheet1.Range("A1").Value
    i tried by using cv = StrConv(Sheet1.Range("A1").Value, vbUnicode)

    Any help would be appreciated.

    rafee


    • Edited by rafee Tuesday, February 12, 2013 4:03 PM
    • Merged by Quist ZhangModerator Thursday, February 14, 2013 3:35 PM Duplicate/VBA language
    Tuesday, February 12, 2013 3:36 AM