VBA Foreign Language not supported for Excel 365 for Mac

Question

VBA Foreign Language not supported for Excel 365 for Mac

Akash Jangir 1

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

I'm getting below output in my .txt file

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

Viki Ji_MSFT 4,471 Reputation points

2021-08-25T02:31:21.287+00:00

Hi @Akash Jangir ,
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.
Akash Jangir 1 Reputation point

2021-08-25T04:05:23.977+00:00

Thanks for the reply @Viki Ji_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.

Your answer

Viki Ji_MSFT 4,471 Reputation points

2021-08-25T02:31:21.287+00:00

Hi @Akash Jangir ,
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.
Akash Jangir 1 Reputation point

2021-08-25T04:05:23.977+00:00

Thanks for the reply @Viki Ji_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.

Share via

VBA Foreign Language not supported for Excel 365 for Mac

Your answer