Convert html to plain text in VBA

by

Set a reference to “Microsoft HTML object library”.

Function HtmlToText(sHTML) As String
  Dim oDoc As HTMLDocument
  Set oDoc = New HTMLDocument
  oDoc.body.innerHTML = sHTML
  HtmlToText = oDoc.body.innerText
End Function

Tim

More Related Contents:

  1. How do HTML parses work if they’re not using regexp?
  2. What to do Regular expression pattern doesn’t match anywhere in string?
  3. How can I efficiently parse HTML with Java?
  4. Scraping html tables into R data frames using the XML package
  5. How to avoid joining all text from Nodes when scraping
  6. Can you provide examples of parsing HTML?
  7. Regex select all text between tags
  8. Scraping data from website using vba
  9. html parsing of cricinfo scorecards
  10. Trouble with parsing table data in perl
  11. What is the best practice to parse html in swift?
  12. HTML-parser on Node.js [closed]
  13. Accessing object in iframe using VBA
  14. Why does a stray end tag generate an empty paragraph?
  15. Parse HTML content in VBA
  16. How can I use the python HTMLParser library to extract data from a specific div tag?
  17. How do I export html table data as .csv file?
  18. Parsing HTML files as PHP
  19. How to save a file from a website as PDF?
  20. Use Excel VBA to click on a button in Internet Explorer, when the button has no “name” associated
  21. HTML parsing in perl
  22. How to extract data from html table in shell script?
  23. How can I extract URL and link text from HTML in Perl?
  24. HtmlAgilityPack Drops Option End Tags
  25. Line Break in XML? [duplicate]
  26. Embedding image in email with VBA
  27. getHTTP with (Excel) VBA?
  28. Parse html using C
  29. How can I resize an image to a percentage of itself with CSS?
  30. How to set thymeleaf th:field value from other variable

Leave a Comment