Special characters and StrConv

Question

i have an xls with text in different languages, which include also german, greek, and so on.

I have to copy these texts to a html file.

The resulting text is not shown as expected, with special characters, like umlauts or greek characters.

For example: i have a cell with the word "öko"

Using something like:(to read)

test = Cells("36", "D").Value

and(to write):

fso.WriteLine ("<title>" & StrConv(test, vbUnicode) & "</title>")

what i see as title in the html file is ??k?o?.

Do i have to install or configure something in my system?

Thanks in advance

I have solved creating the file with the following Statement: **Set ts_html_de = fso_html_de.CreateTextFile(Path_HTML_de, True, True)** — Giovanni De Maio Langella, Mar 13 '18 at 14:19

score 1 · Accepted Answer · answered Mar 13 '18 at 13:26

1

I think you missed a parameter in your OpenTextFile call. If the fourth parameter is -1, then it is Unicode.

answered Mar 13 '18 at 13:26

Sam

yes, i did. Now i am testing with this Parameter, thanks – Giovanni De Maio Langella Mar 13 '18 at 14:08

1 Answers1