Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Sep 2002
    Location
    Victoria, Australia
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Stripping excess html code (Excel 2002 SP-2)

    For sports results publication on the web I am sent an Excel file. Saving as a web page gives an unacceptably large file for members with slow modems. I understand there are utilities available that can strip excess html code from such conversions. Can you point me in the right direction please?

    Thank you

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Stripping excess html code (Excel 2002 SP-2)

    I wouldn't know about a HTML stripper. Wouldn't Zipping the file suffice?

    Also, When you choose the save as webpage option from the FIle menu, you can select just a range to publish. That would dimish filesize too.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    New Lounger
    Join Date
    Sep 2002
    Location
    Victoria, Australia
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Stripping excess html code (Excel 2002 SP-2)

    Thanks Jan, however,
    Zipping is not an option as many of our members wouldn't know what to do with a zipped file. All they want to do is view the results on the screen.

    I had selected a range but size still too large for my liking. Thanks anyway.

  4. #4
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Stripping excess html code (Excel 2002 SP-2)

    Is there a lot of nice formatting involved (colours, borders) ?

    Maybe removing formatting to the absolute minimum would help.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  5. #5
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Stripping excess html code (Excel 2002 SP-2)

    I believe there are addins for Word to save as HTML without all the extra (XML) tags.
    There may be equivalent for Excel.

    The links on this page may provide a good starting point.

    Alan

Posting Permissions

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