Solved

VB Function to Convert HTML output to text in Excel 2007

Posted on 2011-02-23
5
749 Views
Last Modified: 2012-05-11
I am looking for a VB function that can be used in an Excel 2007 workbook to convert HTML data, retrieved from a database into a cell, into plain text.
0
Comment
Question by:MaglinFurniture
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 30

Accepted Solution

by:
SiddharthRout earned 500 total points
ID: 34961207
This should help you :)

http://www.nonhostile.com/page000012.asp

Sid
0
 

Author Comment

by:MaglinFurniture
ID: 34961416
It looks like it would, but, if I use the function, I get a compile error: User defined type not defined, for objRegEx As VBScript_RegExp_55.RegExp. It thinks VBScript_RegExp_55.RegExp is a user defined type (I guess)
I have read that the RegEx object comes with IE 5. IE 8 is installed on the same system on which I am using Excel 2007, so assume the RegEx object should be available and am not sure why this compile error is being generated.

Any idea?
0
 
LVL 30

Expert Comment

by:SiddharthRout
ID: 34961431
Did you add a Visual Basic project reference to: Microsoft VBScript Regular Expressions 5.5 ?

Sid
0
 

Author Comment

by:MaglinFurniture
ID: 34961618
No, I did not. I don't know anything about such requirements. However, I have done that now and everything is working great. Thank you!
0
 
LVL 30

Expert Comment

by:SiddharthRout
ID: 34961621
You are welcome :)

Sid
0

Featured Post

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

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

Find out what you should include to make the best professional email signature for your organization.
Finding original email is quite difficult due to their duplicates. From this article, you will come to know why multiple duplicates of same emails appear and how to delete duplicate emails from Outlook securely and instantly while vital emails remai…
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

739 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