Invoke VBA Encoding Problem

Help Studio
, ,
1

Hi Guys

I have a Problem

I want to use an activity Invoke VBA

*.txt file has chinese(UTF-8)

but VBA read just ANSI Endoing

How can I change Encoding with VBA and execute ???

thx

2

Hi,

Can you try to convert to proper character encoding in advance as the following?

img20210716-1

Regards,

3

thx,

Can I see encoding options?

4

Hi,

Unfortunately, I don’t have environment to check it.
There is a list of encoding for .net. So can you try some Chinese encoding (such as "gb2312")?

Regards,

5

Hello,@111634
1.

image
image1154×161 23.3 KB

2.
image
image750×374 44.2 KB

3.
image
4.You can use this method to export the file format to Bas, and then continue to read the text for operation
Regards.