A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Save as Web Page in Excel 2002



 
 
Thread Tools Display Modes
  #1  
Old June 22nd, 2004, 12:09 AM
Bob
external usenet poster
 
Posts: n/a
Default Save as Web Page in Excel 2002

Is there any way to "tone down" the code that Excel 2002
creates when saving a worksheet as a web page? We
converted to Excel 2002 this past year at work and I was
previously using Excel 97. I have created a VB
application that creates information sheets for 67
different categories at my workplace based on dynamic
pivot tables it creates when I click a button. The
worksheets that are generated are then saved as web
pages. Excel 97 used to create very simple html pages
that I could then apply my own styles to. Excel 2002
seems to create a new style for each change in
justification, font size, emphasis etc. Is there any way
I might be able to get Excel 2002 to create a simple html
page that only retains the font size, tables etc without
all the extraneous CSS and VML? I have Excel 97 at home,
but would prefer to be able to do this here at work now
and in the future. (There are others in my office I've
trained how to use the Save as Web Page feature.)

I tried to change the browser setting under Web Options
to IE 3.0 or later, but all the style codes were still
there.

Thanks, Any help will be greatly appreciated.
Ads
  #2  
Old June 23rd, 2004, 02:49 PM
Brad
external usenet poster
 
Posts: n/a
Default Save as Web Page in Excel 2002

Just a couple of options which may be worth a try:

HTMLtidy (http://tidy.sourceforge.net/) may help
clean up some office code or

If it works with Office XP, Open html in Word and
export using the cleanup filter - Office 2000 HTML
Filter 2.0 - download at:

http://www.microsoft.com/downloads/d...DisplayLang=en

Kind Regards

Brad

"Bob" wrote:

Is there any way to "tone down" the code that Excel 2002
creates when saving a worksheet as a web page? We
converted to Excel 2002 this past year at work and I was
previously using Excel 97. I have created a VB
application that creates information sheets for 67
different categories at my workplace based on dynamic
pivot tables it creates when I click a button. The
worksheets that are generated are then saved as web
pages. Excel 97 used to create very simple html pages
that I could then apply my own styles to. Excel 2002
seems to create a new style for each change in
justification, font size, emphasis etc. Is there any way
I might be able to get Excel 2002 to create a simple html
page that only retains the font size, tables etc without
all the extraneous CSS and VML? I have Excel 97 at home,
but would prefer to be able to do this here at work now
and in the future. (There are others in my office I've
trained how to use the Save as Web Page feature.)

I tried to change the browser setting under Web Options
to IE 3.0 or later, but all the style codes were still
there.

Thanks, Any help will be greatly appreciated.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:33 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 OfficeFrustration.
The comments are property of their posters.