Literally displaying imported cells with <HTML> and <BODY> tags

O

o_cardoso

Hi,
I'm exporting contents to excel from a web application. Each row looks
like this:


"3101" "American Express" "Fort Lauderdale" "FL" "Deployed" "Windows
2001R1" "<![CDATA[<HTML>
<BODY>
<P>
<B>IMPORTANT:</B> We have updated server. You must click the button
again to receive your account information.
<P>
More text goes here
</P>
</BODY>
</HTML>]]>"

However, when the file is opened in Excel only the text in the last
column is displayed (the tags and all the other cells are missing). How
do I get excel to just print all columns and the literal contents
without trying to do anything smart? I know if I get rid of the <HTML>
and <BODY> tags it works, but unfortunately I need to leave them in -
and they need to show up as <HTML> and <BODY>.
Any ideas?

thanks,
Orlando
 
J

Jon Peltier

Orlando -

Here's an ancient piece of code I use for this:

Sub inputTXTfile()
' input text file line by line without interpreting html tabs
' open new sheet first and select home cell

Dim linein As String, fh As Integer, FileName As String, lineNum As Double

FileName = Application.GetOpenFilename
If FileName = "False" Then Exit Sub
Application.ScreenUpdating = False
lineNum = 0
fh = FreeFile
Workbooks.Add

Open FileName For Input As fh
Do Until EOF(fh)
Line Input #fh, linein
ActiveCell.Offset(lineNum, 0) = linein
lineNum = lineNum + 1
Loop
Close #fh

Application.ScreenUpdating = True
End Sub

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
O

o_cardoso

Hi Jon,

Thanks for replying. I'll go figure this out, but if you have a second
can you explain where the Application and ActiveCell objects come from?
I was just writing directly to Response.Write, setting the content type
to excel, and letting Windows just open the file naturally from the
association. It looks like you're directly manipulating excel, which is
an avenue I haven't investigated before.

Thanks again,
Orlando
 
D

Dave Peterson

Jon's code is a macro that's run from inside excel.

Application is Excel (itself) and Activecell is a range object within excel.
Activecell represents the cell that's selected (or if the selection is
multi-cells, it represents the "white" one in that selected area).

You may want to read David McRitchie's intro to macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Concatenating cells with ones that contain html tags and quotation marks? 1
Hello...This thread is a continuation of one from 2003...pasted below: 2
c#.NET get text between body tags of an html file 4
XML export with <![CDATA[text]]> 0
Extract specific information from the body of outlook mail to an Excel File using VBA 0
Adding HTML tags to cell content 1
How do I get HTML codes in an Excel Spreadsheet to display or conv 2
Remove html markup tags in an EXCEL cell? 3

Top