Scripting a CSV / Excel Export

The Export as Excel / CSV function only allows global access to the function, rather than table by table.

It would be good if exporting an Excel or CSV could be scripted into a button, stipulating the view from which the file is generated - this would then lend well in scheduling excel reports to email out at regular intervals, rather than giving all users the export function and requiring a manual process to export.