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 create 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.
I needed this as I have a Tcl script which parses test result log files and creates a csv summary file which I load into an external reference table in Excel and from that update test result status in another worksheet. I have very little patience for repeatedly running the script then updating the Execl external reference so I wanted a single button click update. I haven't quite achieved this as I still need to confirm the opening of the csv file when updating the Excel external reference. I've very little knowledge of VBA so this has been a learning experience.
To download go to http://tcl.glennh.com and save demo.xls and demo.tcl to a local directory.
This was developed with Excel 2002. This method does not work with Excel 2000 - because I'm using Active X I think.
Lauri Ojansivu has kindly sent me an updated excel file which runs the tcl script and updates the spread sheet with a single button press. You can get this from the URL mentioned above 'demo-2.xls'.
Here is modified Excel file & original Tcl file: http://www.xet7.org/tcl
Some notes about modifications:
Worksheets("Sheet2").Range(Trim(Chr(Asc("A") + C)) & Trim(Str(R + 2))).Value = _