Using VBA I have been able to attain and place strings like the below within an excel cell. But they currently still contain both html tags and entities, How can I show these in their appropriately formatted form within an excel cell?
I have attempted many of the approaches already suggested within different stack overflow threads, but as they all focus toward the Windows O.S most make use of libraries and browsers which the Mac version of excel simply doesn't have access to.
Errors such:
Run-time error '429:
ActiveX component can't create object
When attempting this approach:
Or this approach:
Compiler Error: User-Defined Type not defined
When attempting this approach:
The closest I have gotten is finding [this approach][6], to find and replace a list of html entities with their corresponding symbols:
But this doesn't cover html codes such as
or apply appropriate styling as indicated by the presence of html tags such
or
etc.
Any suggestions would be thoroughly appreciated. Thank you.
Bookmarks