VBA cells to .html but with UTF8 encoding

[sportbo]

Hey to All!

I hav got the following problem. I use a macro for exporting cells to .html documents.
The Problem is that afterwards i need to upload these documents into a company system, which doesnt recognise them because
they are ANSI.

I have read that I need to use Adobe.streams in order to export as UTF8, but I have no Idea how to integrate it to my code.

Please Login or Register  to view this content.

[romperstomper]

The code you have does not appear to save the workbook in html format, it simply saves a workbook with .html as the file extension. You should be using:

Please Login or Register  to view this content.

[sportbo]

Thank you Rorya,

but the encoding still is ANSI.

[Marc L]

Hi !

I have read that I need to use Adobe.streams in order to export as UTF8, but I have no Idea how to integrate it to my code.

ADODB.Stream save normal text, not to a html format, samples to see on forums …
But if you know the html language you can save the text incorporing html stuff via ADODB.Stream …

If not, you can use the Excel feature Save As to first create the html file
then compare with a correct html file what you need to add in your file, see with your IT or the Web guy …

[Marc L]

Last point : documentation of ADODB is on MSDN website …