Excel report on a daily basis

[Straatvark]

I must create a Excel report on a daily basis.

Can someone maybe comment on my design/approach listed below?

1)Create a SQLExec that connects to the Citadel ODBC Database
2)Create a DataTable object to link to a xls file
3)Do queries on the SQLExec and some calculations
4)Write the results to the xls file
5)Activate some macros on the xls file from Lookout

[Chad E]

I found an example that does most of this: Querying Citadel Database and Exporting Data to Excel
. See also Citadel ODBC Queries using Lookout SQLexec.

For the last step, write the macros that you need in Excel so that they run according to the value of a "command" cell. Then use Lookout to change the value of that cell to run the respective macro.