NEEDED: Excel macro to export HTML markup cells to PowerPoint and retain styling

[fission99]

I am involved in converting ASP e-elearning courses to Storyline. These ASP courses are defined by Excel documents. The Excel documents are broken down to three worksheets: Training, Question and Exam. (I'm focusing today on the Training worksheet.)

Storyline allows for the importation of PowerPoint documents.

So my process has been this:

• Export the Training worksheet into PowerPoint using a macro & a few functions, then
• import the generated PowerPoint into Storyline.

This has worked well except for one thing: some of the cells, most notably the body content of the Training worksheets, have HTML markup in them. (So much for separating style from content!) I would really like to reuse this markup, that is to say, export it to PowerPoint so that the PowerPoint slides are formatted, rather than just plain text.

I have not figured this out as of yet. My fallback position is to generate a folder of HTML documents, slide-by-slide, during the export process, that can then be cut & pasted after the process in the body content of the PowerPoint slides.

I'm looking for a macro that will take an HTML-marked-up string and turn it into a styled string that survives the export to PowerPoint, thus rendering in PowerPoint as a styled string.

Any ideas would be appreciated! Please include the references included.