Dear Experts,

I have extracted all chapters of a Word document into Excel worksheet chapter after chapter.

The exported text is formatted with bold, italicized and tabular formatting.

I tried to use the SaveAs function with FileFormat:=xlHtml but due to limitations in our company it is not allowed to save .html files in the file system.
But if I could put the hmtl code in an excel spreadsheet in a special cell then the problem would be solved.

The point is that i need the formatted text, tables etc. but I don't need a .html file, but instead would like to put the html code into a cell in Excel.

I have the following code:

Please Login or Register  to view this content.
Is it possible to put the HTML code generated by this function in an Excel cell?

Thanks for your help.

Best Regards
Moloko