> All I really need to do is have all of the queries (there's a dozen or so) update
> when the book is opened, and then run some code on the data when the
> updates are complete.

You are talking about building a Excel macro which automatically runs based on the "Workbook_Open" event.

That macro would be able to force an update to the external tables and then run your own custom code/formulas.

You are really getting into Excel, not Firebird issues, since you are now able to work with ODBC connections, MS Query and external tables/data.


Sean