I am exporting charts from my spreadsheets to folders with html pages so
people can browse the charts.

The HTML code refrences the pre set locations.

I can make a button press automate the creation, exporting etc but I cant
run it without going into the spreadsheet. The reason I dont want to is
because I dont want certain people to be able to run the update because it
needs to be run at an exact time. If I could automate it somehow it would
always be perfect and so I could forget about it and the charts would be
created and updated themselves.

Thanks for any suggestion.

Rob