Page 1 of 2 12 LastLast
Results 1 to 15 of 18
  1. #1
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Atlanta
    Posts
    568
    Thanks
    7
    Thanked 1 Time in 1 Post

    Cleaning up HTML (97 & XP)

    With Office 97, I could paste text from Word or Excel into FrontPage 97 and get fairly clean HTML. Office XP is not smart enough to handle this fairly simple task. It adds a lot of extra junk, especially with Excel XP. I can run MS Filter to get rid of a little bit of this fat but a bunch remains. Any suggestions on how to either make Office XP work as well as Office 97 or a utility that will truly clean up the bloated files Office XP produces?

    Ronny
    Ronny Richardson

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Cleaning up HTML (97 & XP)

    I paste to Notepad, then copy from there and paste into FrontPage. But this might not be slick enough for your needs.

    Many solutions have been suggested in the past but I'm not sure that a satisfactory one really has been found. Boards to search include this one, as well as the application boards (Word and Excel) and the Web Design forum. Good luck!!

  3. #3
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Atlanta
    Posts
    568
    Thanks
    7
    Thanked 1 Time in 1 Post

    Re: Cleaning up HTML (97 & XP)

    That is a good idea for handling Word files. Thanks, I'll start doing that. I would not, of course, work with Excel files. They get blasted a lot worse than Word files do.

    Ronny
    Ronny Richardson

  4. #4
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Cleaning up HTML (97 & XP)

    You might want to check out <post#=242602 >post 242602 </post#>, I didn't test Excel - so I'd be interested in your results.

    Cheers
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  5. #5
    Lounger
    Join Date
    Feb 2001
    Posts
    48
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cleaning up HTML (97 & XP)

    Ronny,

    (The following is a repeat of an earlier broadcast..) I also have found that Word XP (2002) puts an excessive amount of overhead code in FrontPage 2000. What I have done is copy from Word to the buffer and then in FrontPage 2000 perform a Paste Special - Normal Paragraphs with line breaks (edit/paste special). This will reduce all the 'junk' that Word added. Note that if you have any special formatting in Word you will lose it upon a Paste Special. Anyway, play with it until you find a satisfying setting.

    LMD

  6. #6
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Cleaning up HTML (97 & XP)

    Do you do VBA? Hans posted a VBA procedure for Excel that converts it to a table for the Lounge. Lounge markup is very similar to HTML, so with a little tweaking (start by switching [ and ] brackets to < and >), it just might do what you need (you'd paste directly into the HTML pane). Check out <post#=164109>post 164109</post#>.

  7. #7
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Atlanta
    Posts
    568
    Thanks
    7
    Thanked 1 Time in 1 Post

    Re: Cleaning up HTML (97 & XP)

    I'm afraid I don't know the first thing about VBA. Anyway, Office 97 keeps the shading when I do the paste and I would really like to do that. I am a teacher and I am posting my grade book online. (Students have codes not names.) I shade any assignment that was not turned in as red. That helps the students spot what they are not doing.

    Ronny
    Ronny Richardson

  8. #8
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Atlanta
    Posts
    568
    Thanks
    7
    Thanked 1 Time in 1 Post

    Re: Cleaning up HTML (97 & XP)

    That seems to be the tradeoff, lose your formatting or keep all the crap Microsoft adds to the file.

    Ronny
    Ronny Richardson

  9. #9
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Atlanta
    Posts
    568
    Thanks
    7
    Thanked 1 Time in 1 Post

    Re: Cleaning up HTML (97 & XP)

    His method #5 is the only one he found that worked great:

    Method 5 - Double Filter the Word Document and Insert into FrontPage.
    First save the Word document as "Filtered" HTML.

    Excel does not appear to have a Filtered HTML option so the only good method he found cannot be used with Excel. I suspose I could paste the table into Word and then use this approach.

    I tried Excel -> Word -> MSClean -> FrontPage and it worked no better than a direct paste. In fact, it did worse since Word created the little GIF boxes and scattered dozen or more around my table.

    Interestingly, the HTML file was 2K larger after it was "cleaned" than before. Something strange is going on here.

    Ronny
    Ronny Richardson

  10. #10
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Cleaning up HTML (97 & XP)

    With a bit (okay a lot!) of work I was able to capture two color fills, yellow and red. Here's how you'd use it:

    1. <LI>Open the attached workbook (Enable macros) and your source workbook.
      <LI>In your source workbook, select the cells you want in your HTML page.
      <LI>Press Alt+F8 to open the Macros dialog and choose the one macro (I'd include the name, but i forgot to make a note of it before closing Excel).
      <LI>Assuming it doesn't mention any errors ( <img src=/S/crossfingers.gif border=0 alt=crossfingers width=17 height=16>), the table code is on the clipboard and you now can paste it into the HTML pane of your FrontPage document.
    I tested in Excel 2002. Does it work for you?
    Attached Files Attached Files

  11. #11
    New Lounger
    Join Date
    Feb 2004
    Location
    Portland, Oregon
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cleaning up HTML (97 & XP)

    Is there a program that can clean up FrontPage generated HTML and take out all the redundant and unnecessary tags it adds?

  12. #12
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Cleaning up HTML (97 & XP)

    Which version of FP are you working with?
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  13. #13
    Gold Lounger Rebel's Avatar
    Join Date
    Jul 2001
    Location
    Canada
    Posts
    3,024
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Cleaning up HTML (97 & XP)

    Check out this site - http://www.vorburger.ch/kissfp/. KissFP does a great job. I've used it with FP2000, XP and 2003. You'll have to pay for it but it's been invaluable to me.
    John
    A Child's Mind, Once Stretched by Imagination...
    Never Regains Its Original Dimensions

  14. #14
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Atlanta
    Posts
    568
    Thanks
    7
    Thanked 1 Time in 1 Post

    Re: Cleaning up HTML (97 & XP)

    Frontpage 97. Until this pasting thing came up with Office 2000/XP, it worked great and met all my needs so I never saw a reason to "upgrade".

    Ronny
    Ronny Richardson

  15. #15
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Atlanta
    Posts
    568
    Thanks
    7
    Thanked 1 Time in 1 Post

    Re: Cleaning up HTML (97 & XP)

    It is a good start. It does run without error and it transfers the data without any of the junk. With a straight Excel-->Frontpage (I use 97) you can paste into the regular screen. After running this macro, you have to be sure to paste in the HTML view. That is not a problem.

    The macro seems to strip out all the formatting. That is actually better than having the junk Microsoft adds and might be easier to work around. As you can see from the attached before (Excel) / after (Frontpage 97) it removes:

    1. Background colors
    2. Cell merges (minor)
    3. Number formatting
    4. Cell formatting, e.g. Bold

    I don't know how much of the problems are due to my using the older Frontpage 97 rather than newer versions.

    Ronny

    PS: This is my gradebook so I've erased all names.
    Attached Images Attached Images
    Ronny Richardson

Page 1 of 2 12 LastLast

Posting Permissions

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