VBA Formatting cells with Html tags read from XML

		Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
VBA Formatting cells with Html tags read from XML

Excel VBA Discuss using VBA for Excel programming.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

November 22nd, 2006, 02:41 AM

hemagiri

Registered User

Join Date: Nov 2006

Posts: 1

Thanks: 0

Thanked 0 Times in 0 Posts

VBA Formatting cells with Html tags read from XML

Hi All,

I am Parsing an xml file in which i have a CDATA section containing html tags(shown below in the bold).

<FeedbackBoxTitle><![CDATA[<p align='left'><B>Feedback</B></p>]]></FeedbackBoxTitle>

I want write the above kind of data to a cell in excel by applying formatting given in html tags.

Is there any inbuilt method that takes care of html data.

Do let me know your thoughts.

thanks in advance,
Hemagiri

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formatting the cells from VBA	yogeshyl	Excel VBA	1	July 20th, 2007 12:26 AM
DHTML - Div tags causing table cells to expand ve	clem_c_rock	HTML Code Clinic	5	September 12th, 2006 02:03 PM
XSLT help : Interpretting HTML tags from XML	kunal_kishan	XSLT	1	June 26th, 2006 05:37 AM
Trouble with formatting text in table cells!	Sickopuppie	HTML Code Clinic	5	June 21st, 2006 03:17 AM
Formatting e.Item.Cells in Datagrid	rstelma	ASP.NET 1.0 and 1.1 Professional	18	February 26th, 2006 07:34 AM