Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

VB Function to Convert HTML output to text in Excel 2007

Posted on 2011-02-23
5
Medium Priority
?
753 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 2000 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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Originally, this post was published on Monitis Blog, you can check it here . In business circles, we sometimes hear that today is the “age of the customer.” And so it is. Thanks to the enormous advances over the past few years in consumer techno…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

604 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