save as html

  • Thread starter Thread starter Lynwood Dunseith
  • Start date Start date
L

Lynwood Dunseith

Hello,

Is there any way, or a macro, that will allow me to save a worksheet in
Office XP as HTML without using style tags (like office 97). I don't
need, or want, excel to do CSS for me.

Thanks,

Woody
 
I think that you may find it less frustrating to just create the table
Frontpage or other html editor than trying to convert an Excel sheet to
html. At least, that has been my experience.
 
Hi Woody,
See my page
Excel to HTML conversions
http://www.mvps.org/dmcritchie/excel/xl2htmlhtm

Pasting an Excel table into Front Page will result in ten times the
amount of code as creating your own table. Since you are concerned
about not generating CSS code, I'm sure working with HTML is not
a problem for you.

You could then paste
the generated code into Front Page and work with it there with the
rest of your document without bloating it up, because it won't know
a thing round tripping it to Excel. If you do use Front Page afterwards
make sure you save a backup copy first. There is an option in Front Page
that you would want to make sure you have turned on.
Tools, Page Options, HTML Source (tab),
[x] Preserve existing HTML
Watch the META tags in your HTML Header if they indicate
Front Page as the generator then you know Front Page has done
something more to your code than you probably wanted..

The page above also includes more information on HTML that you
might find useful.

The .misc, .programming, and worksheet.functions newsgroups are
the main groups that I am in. I do not have a MAC and I only answered
a similar question of yours on a MAC newsgroup because I was looking
in the Google newsgroup archives probably for your posting here in .misc
that I'd lost track of..
Excel Newsgroups & Searching Newsgroups
http://www.mvps.org/dmcritchie/excel/xlnews.htm

HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
 
Back
Top