+ Reply to Thread
Results 1 to 2 of 2

Help for the use of write <end of line> to html file.

  1. #1
    Forum Contributor
    Join Date
    02-18-2014
    Location
    hk
    MS-Off Ver
    Excel 365
    Posts
    105

    Help for the use of write <end of line> to html file.

    Hi All,

    I store a content of html file to cells(1,1) and write to a html file. but the result is that the content of html is on a single line.

    The following is the information and you would find the attached file.
    The cells(1,1) like that
    <html>
    test
    </html>

    but the output file like that
    <html> test </html>
    Please Login or Register  to view this content.
    I know I can use "open xxx.html as #1 for writing" and "print #1, line1" to write line by line. but the code will become very long.
    Can I have other methiod? Thanks.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    06-25-2009
    Location
    Sofia, Bulgaria, EU
    MS-Off Ver
    Excel 2003-2013
    Posts
    1,290

    Re: Help for the use of write <end of line> to html file.

    try this, maybe it will help:

    Please Login or Register  to view this content.
    Last edited by buran; 03-29-2015 at 02:36 AM.
    If you are pleased with a member's answer then use the Star icon to rate it.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 7
    Last Post: 01-18-2015, 06:16 PM
  2. VBA to Import HTML Table Locally Stored HTML file to excel
    By ermengard in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 01-09-2015, 10:48 AM
  3. [SOLVED] VBA write value from html to cells
    By lafanker in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-28-2014, 09:59 PM
  4. Write a string of text to all HTML files
    By tomlancaster in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-18-2010, 06:14 AM
  5. Inserting html line breaks into excel.
    By Ben Allen in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-18-2005, 11:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1