question

AkashJangir-9034 avatar image
0 Votes"
AkashJangir-9034 asked AkashJangir-9034 edited

VBA Foreign Language not supported for Excel 365 for Mac

Hi,

I'm trying to create a .txt file out of my excel sheet which has 'Korean' Characters in the sheet.
When I try to read those char in a String variable its not showing the characters properly. It shows (__) instead of actual Korean characters.
Same code is working in Windows but not working in Mac

My excel sheet has this data. Please see the screen shot attached

126014-screenshot-2021-08-24-at-42028-pm.png


I'm getting below output in my .txt file

125937-screenshot-2021-08-24-at-42658-pm.png


Below is the code I'm using.

 OutputFileNum = FreeFile
 Open fileSaveName For Output Lock Write As #OutputFileNum
 Appender = "Some text from sheet"
    
 Print #OutputFileNum, Appender


office-vba-dev
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @AkashJangir-9034,
Welcome to Q&A forum!
Since your issue is more related to VBA, I have removed the tag office-for-mac-itpro that focuses on general issues about Microsoft Office for Mac.
Thanks for your understanding!
Besides, please check if danishani's reply in this thread is helpful.
Hope you get an answer soon.

0 Votes 0 ·

Thanks for the reply @VikiJi-MSFT, but that doesn't help with my use case.

My use case is to read the data from sheet and write it to text file. But VBA is not able to understand non-ASCII (Korean Characters).

In Windows, VBA compiler is able to understand the non-ASCII chars. But in Mac VBA compiler doesn't understand the chars and stores some garbage values in the variable.

0 Votes 0 ·

0 Answers