Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automate 'Publish as Web Page'?
Good day!
Is it possible to automate the 'Publish as Web Page'? Because my source Excel file would be changing quite often, and I want to produced the HTML automatically. Thank you very much. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automate 'Publish as Web Page'?
Good Morning,
Yes it is possible to automate that process. I am going to give you instructions for Excel 2003, if you have another version the instruction should be similar. Get your data set up the way you want then "save as web page" a new dialog box will pop up asking you what you want to save (single worksheet or whole workbook); where you want to save it to (publish it to) and if you would like to add interactivity. side note: you can also just publish a selection of cells within a work sheet or a chart. You will also see a button that says publish. Click this and it will open a new box that will confirm your choices again and gives you a choice to AutoRePublish any time the file is saved normally (as an *.xls file). Rich Webb "dyowee" wrote: Good day! Is it possible to automate the 'Publish as Web Page'? Because my source Excel file would be changing quite often, and I want to produced the HTML automatically. Thank you very much. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automate 'Publish as Web Page'?
Hi!
But it still is required to do it manually for the first time. Is it possible to do it programmatically? Thanks. " wrote: Good Morning, Yes it is possible to automate that process. I am going to give you instructions for Excel 2003, if you have another version the instruction should be similar. Get your data set up the way you want then "save as web page" a new dialog box will pop up asking you what you want to save (single worksheet or whole workbook); where you want to save it to (publish it to) and if you would like to add interactivity. side note: you can also just publish a selection of cells within a work sheet or a chart. You will also see a button that says publish. Click this and it will open a new box that will confirm your choices again and gives you a choice to AutoRePublish any time the file is saved normally (as an *.xls file). Rich Webb "dyowee" wrote: Good day! Is it possible to automate the 'Publish as Web Page'? Because my source Excel file would be changing quite often, and I want to produced the HTML automatically. Thank you very much. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automate Page Breaks | Excel Discussion (Misc queries) | |||
Publish as Wed Page | Setting up and Configuration of Excel | |||
How to publish an Excel worksheet as a Web page including heading | New Users to Excel | |||
When I publish a web page that's supposed to be interactave it be. | Excel Discussion (Misc queries) | |||
Difference between Publish and Save As Web Page in Excel 2002 | Excel Discussion (Misc queries) |