VBA cells to .html but with UTF8 encoding

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.

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.

Thank you Rorya,

but the encoding still is ANSI.

Hi !

Originally Posted by sportbo

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 …

Last point : documentation of ADODB is on MSDN website …