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.