PDA

View Full Version : Read from txt file in utf-8



antonin
01-05-2006, 12:19 AM
I use the scripting method


Set fs = CreateObject("Scripting.FileSystemObject")
Set f = fs.OpenTextFile(path, 1, x)


for reading from a text file which is in the utf-8 charset. Whichever of the three values {0, -1, -2} I use for x above, the characters are not displayed propely (I use the text from the file for writing into cells).

What can I do about it?

Antonin

stanl
01-05-2006, 08:34 AM
You might consider using an ADODB.Stream which has a charset property. See.

http://www.w3schools.com/ado/ado_ref_stream.asp

.02

Stan