0

I have a question regarding VBA macro, I've tried to write a sample code and it happens that Japanese characters are resulting to "???" when I copy then paste it to my VBA code.

Expected Result of pasted link:

C:\Users\username\folder\Global - 新しいフォルダ - Sample

Actual output of pasted link in vba:

C:\Users\username\folder\Global - ???????-GREAT????? - Sample

I tried to debug it but it has the same output, may I know what seems to be the problem? Below picture was my code and I also checked the region of my machine and it was already set in Japanese(Japan) format.

enter image description here

Thank you in advance for the solutions and other ways to fix it. I will appreciate it all :)

GSerg
  • 76,472
  • 17
  • 159
  • 346
Josel Gabalones
  • 3
  • 2
  • There is no picture (below or somewhere else). Anyhow, code pictures are not good to be shown, since you can paste the code text, as it is... It is, anyhow, more complicated to make a picture, instead o pasting it. Please, edit the question and paste the code in discussion. – FaneDuru May 20 '22 at 06:50
  • Sorry, I didn't notice that I not included the picture, it is now updated. Thank you :) – Josel Gabalones May 20 '22 at 07:40

1 Answers1

0

did you try changing your Office default display language?

Also you can try this: Using Multiple Languages In VBA

Batuhan
  • 38
  • 1
  • 5
  • Thank you @BatuhanGez for the answer, it seems that my Japanese Language in display language hat not been installed yet. I'll come back here for the updates in accordance of your solution. Thank you so much :) – Josel Gabalones May 20 '22 at 08:03