?
Solved

Excel VBA - convert formatted cell contents as html

Posted on 2011-04-20
4
Medium Priority
?
501 Views
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?

TIA
0
Comment
Question by:Philip Pinnell
  • 2
  • 2
4 Comments
 
LVL 33

Expert Comment

by:jppinto
ID: 35431506
Please take a look at this link:

http://charlie.balch.org/hdoc/exceltohtml.html

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

Hope it helps,

jppinto
0
 
LVL 13

Author Comment

by:Philip Pinnell
ID: 35431614
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
0
 
LVL 33

Accepted Solution

by:
jppinto earned 2000 total points
ID: 35431627
0
 
LVL 13

Author Comment

by:Philip Pinnell
ID: 35439727
Thanks

I have something working based on that
0

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this post, I will showcase the steps for how to create groups in Office 365. Office 365 groups allow for ease of flexibility and collaboration between staff members.
MS Outlook undoubtedly is the most widely used email client.Its user-friendliness, cost effectiveness, and availability with Microsoft Office Suite make it the most popular email application.  Its compatibility with Microsoft applications like Exch…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

864 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