|Subject||RE: [firebird-support] A different solution|
> All I really need to do is have all of the queries (there's a dozen or so) updateYou are talking about building a Excel macro which automatically runs based on the "Workbook_Open" event.
> when the book is opened, and then run some code on the data when the
> updates are complete.
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.