Excel VBA - convert formatted cell contents as html

Posted on 2011-04-20
Last Modified: 2012-05-11
I wnat to be able to take the formatted contents of a cell and convert it to html in VBA

Any ideas?

Question by:Philip Pinnell
    LVL 33

    Expert Comment

    Please take a look at this link:

    It has a set of macros to convert Excel into HTML.

    Hope it helps,

    LVL 16

    Author Comment

    by:Philip Pinnell
    I just need to convert a single cell and convert this to html so any bold or undelined text for example in the cell get htnl mark up
    LVL 33

    Accepted Solution

    LVL 16

    Author Comment

    by:Philip Pinnell

    I have something working based on that

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    Not long ago I saw a question in the VB Script forum that I thought would not take much time. You can read that question (Question ID  ( Here (http…
    In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
    The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now