Export a table to an Excel file whose name carries today's date, then let the scheduler write it every weekday. A 1:11 full-HD video recorded on the real ATX AnalyticsTable application, part of the automated excel and pdf reports tutorials.
A parameter such as asOf = =TODAY() formatted YYYYMMDD can be used in any file name. Put it in an Excel export, schedule the export, and every weekday produces a new file — sales_20261013.xlsx, then the next day's — without anyone opening the application.
Settings → Parameters → asOf → Export → Excel → Flat file → Schedule → Add → Run now
This site needs JavaScript for the full experience. Every page above is reachable without it.