Excel web template - need some assistance please!

[Mark G.]

When using the option to save an excel file with multiple sheets, I elect to
"save as a webpage". Works great and looks good with some formatting editing
in the file. But I am curious, when "saving to a webpage", is there a way to
get Excel to use a template file? For instance, a webpage already setup with
the background color and other things. Seems like it should be able to get
done, but I could not find anything! Thanks much.

 

[Anne Troy]

Mark: I believe that would require some VBA. The only alternative I can
think of, but did not test... Save Excel as HTML, then open that html with a
text editor, copy it, and paste it into another HTML file (template). You
may need to be careful that you don't copy "head" and "body" tags, etc...
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

 

[Mark G.]

Thanks Anne. Anyone else have any good ideas?

Mark: I believe that would require some VBA. The only alternative I can
think of, but did not test... Save Excel as HTML, then open that html with a
text editor, copy it, and paste it into another HTML file (template). You
may need to be careful that you don't copy "head" and "body" tags, etc...
************
Hope it helps!
Anne Troy
www.OfficeArticles.com