Solved

VB Function to Convert HTML output to text in Excel 2007

Posted on 2011-02-23
5
746 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
  • 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Whether you’re a college noob or a soon-to-be pro, these tips are sure to help you in your journey to becoming a programming ninja and stand out from the crowd.
Use these top 10 tips to master the art of email signature design. Create an email signature design that will easily wow recipients, promote your brand and highlight your professionalism.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
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…

867 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

21 Experts available now in Live!

Get 1:1 Help Now