Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 755
  • Last Modified:

VB Function to Convert HTML output to text in Excel 2007

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
MaglinFurniture
Asked:
MaglinFurniture
  • 3
  • 2
1 Solution
 
SiddharthRoutCommented:
This should help you :)

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

Sid
0
 
MaglinFurnitureAuthor Commented:
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
 
SiddharthRoutCommented:
Did you add a Visual Basic project reference to: Microsoft VBScript Regular Expressions 5.5 ?

Sid
0
 
MaglinFurnitureAuthor Commented:
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
 
SiddharthRoutCommented:
You are welcome :)

Sid
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now