ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Changing the way it saves (https://www.excelbanter.com/excel-programming/351170-changing-way-saves.html)

Mark G.[_2_]

Changing the way it saves
 
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.



Gordon Rainsford[_3_]

Changing the way it saves
 
Mark G. wrote:

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.


I found this on the web: http://www.meadinkent.co.uk/xlhtmltable.htm

I adapted it for my own purposes so that it uses my standard format
webpage, and inserts the values in CSS columns instead of tables, and it
works great like that too. There's lots of scope there for playing
around with it once the basic idea has been incorporated.

--
Gordon Rainsford

London UK


All times are GMT +1. The time now is 10:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com