+ Reply to Thread
Results 1 to 1 of 1

(On MacOS) How can I format (or decode) HTML entities and tags in excel using vba?

  1. #1
    Registered User
    Join Date
    03-13-2021
    Location
    Narnia
    MS-Off Ver
    Latest (for MacOs)
    Posts
    1

    Question (On MacOS) How can I format (or decode) HTML entities and tags in excel using vba?

    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?

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    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:

    Please Login or Register  to view this content.
    Or this approach:


    Please Login or Register  to view this content.

    Compiler Error: User-Defined Type not defined

    When attempting this approach:

    Please Login or Register  to view this content.
    The closest I have gotten is finding [this approach][6], to find and replace a list of html entities with their corresponding symbols:

    Please Login or Register  to view this content.
    But this doesn't cover html codes such as
    Please Login or Register  to view this content.
    or apply appropriate styling as indicated by the presence of html tags such
    HTML Code: 
    or
    HTML Code: 
    etc.

    Any suggestions would be thoroughly appreciated. Thank you.
    Last edited by AnswerReady; 03-13-2021 at 09:53 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. HTML Translation - decode
    By tolgaulus in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-04-2021, 07:52 PM
  2. Convert HTML tags to Excel text format
    By CristianCGP in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-28-2020, 09:49 PM
  3. Need formula to decode HTML to normal text
    By papusale in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-22-2015, 11:46 AM
  4. Removing HTML tags (specifically <p> tags)
    By furiousbob in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 07-02-2015, 11:27 PM
  5. [SOLVED] Using HTML tags in Excel VBA
    By Excel Guy 123 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-18-2014, 12:44 PM
  6. convert formated excel column to html source text with html tags
    By julia81 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-19-2011, 04:22 PM
  7. [SOLVED] Replacing HTML Tags in Excel
    By Darlene in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-28-2005, 03:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1