Is it possible to grab the contents of a cell (containing formatted/rich text) and load that directly into a webbrowser control in a userform, without first saving this content as a separate file (a web page / XML page)?
I have tried doing things like:
Me.WebBrowser1.Object.Document.Write = ThisWorkbook.Worksheets("Sheet1").Range("F4").Value(xlRangeValueXMLSpreadsheet)
Me.WebBrowser1.Object.Document.Write = ThisWorkbook.Worksheets("Sheet1").Range("F4").Value(xlRangeValueMSPersistXML)
but that doesn't work (even though I've confirmed getting XML data from those Value calls).
Is there something I have to do with the XML string to get the webbrowser control to recognize it as a valid XML file that it can display? (maybe something with the XmlNamespace?
Thanks in advance!
I have tried doing things like:
Me.WebBrowser1.Object.Document.Write = ThisWorkbook.Worksheets("Sheet1").Range("F4").Value(xlRangeValueXMLSpreadsheet)
Me.WebBrowser1.Object.Document.Write = ThisWorkbook.Worksheets("Sheet1").Range("F4").Value(xlRangeValueMSPersistXML)
but that doesn't work (even though I've confirmed getting XML data from those Value calls).
Is there something I have to do with the XML string to get the webbrowser control to recognize it as a valid XML file that it can display? (maybe something with the XmlNamespace?
Thanks in advance!
