Open a new Excel workbook. Use "View/Toolbars" to show the Forms toolbar. From the Forms toolbar, place a Button on the sheet. Give it the label, "Push me".
...
I have an example of Excel calling a Tcl script which creates a csv data file which is then loaded into excel as external data.
The path of the tcl script and the csv file that the tcl script is to craete are set in the spreadsheet cells.
When the 'update' button is clicked the Tcl script is executed then the external data table in the spreadsheet is updated.
It's not 100% automated but it's a good start.
There are still problems with error handling - e.g when you slect 'cancel' when selecting the csv file for the external data update.
To download go to http://tcl.glennh.com and save demo.xls and demo.tcl to a local directory.
To run:
This was developed with windows XO and Excel 2000. This method does not work with Excel 2000 - because I'm using Active X I think.