LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11
Default Strange effect when exporting as text file

Hello

In Excel I'am trying to export a sheet with some simpel HTML formating
as txt file

In a sheet i have the following data: (all cells in the sheet ar
formated as text)

A1 = Content=<p</p<u<bTitel:</b</u<p</p<p</p<p</p
A2 = <b<font size="42"Data</b</font<p</p<p</p"


When i save it as text file there appear some extra qoute's,
Line 1 is good but line 2 has some extra quote's witch where not visible
in the sheet



The created text file:
Content=<p</p<u<bTitel:</b</u<p</p<p</p<p</p
"<b<font size=""42""Data</b</font<p</p<p</p"


See the qoute at the beginning and end of line 2 and the extra quotes
arrond the 42, Again these where not visible in the sheet



I have created the values in A1 and A2 using the following:
Range("A1").Value =
"Content=<p</p<u<bTitel:</b</u<p</p<p</p<p</p"

Range("A2").Value ="<b<font size=" + Chr$(34) + "42" + Chr$(34) + "" +
DataString + "</b</font<p</p<p</p"


Can someone explain this to me please

Ps.
Exporting as HTML is not an option as this creates a bloated HTML file
witch is not understood by flash where i want import the text file. XML
is not an option because of Office97.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Exporting excel to text file Exceluser Excel Discussion (Misc queries) 1 July 1st 05 03:04 AM
Exporting excel to text file Exceluser Excel Discussion (Misc queries) 1 June 29th 05 05:26 AM
Exporting excel to text file Exceluser Excel Discussion (Misc queries) 1 June 22nd 05 05:33 AM
Exporting Date to Text File Dan T[_2_] Excel Programming 2 July 8th 04 01:25 PM
Exporting Text File Ray Ray[_2_] Excel Programming 1 August 17th 03 03:33 PM


All times are GMT +1. The time now is 07:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"